Need to download oracl-fdw? It's hard to go thru so many processes, need to download, transfer information to somewhere, ask for permission to burn into a CD/DVD, burn a CD/DVD, file a paperwork to move software from CD/DVD to server.
Is there a way I can use those software already downloaded and transferred to the server?
I am asking where should I install ora2pg? on oracle db server or postgres db server? I saw DBD-Oracle-1.52 tar and DBD-pg-2.19.3.tar, http://ora2pg-samrat.blogspot.com/ but didn't say which one is install on which?
the information is not really clear and may you help me out?
thank you.
Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success
On Wednesday, January 16, 2019 3:23 PM, "gilberto.castillo@xxxxxxxxx" <gilberto.castillo@xxxxxxxxx> wrote:
Answer interline.
El 2019-01-16 15:17, Pepe TD Vo escribió:
> sorry to ask, what is oracle_fdw
oracle_fdw is extension for pg (foreign data wrapper)
> do I need to download this oracle_fdw and where should I install it,
> on oracle server or postgresql server?
You can to install in pg server or wherever.
>
> thank you.
>
> Bach-Nga
>
> No one in this world is pure and perfect. If you avoid people for
> their mistakes you will be alone. So judge less, love and forgive
> more.
> To call him a dog hardly seems to do him justice though in as much as
> he had four legs, a tail, and barked, I admit he was, to all outward
> appearances. But to those who knew him well, he was a perfect
> gentleman (Hermione Gingold)
> **Live simply **Love generously **Care deeply **Speak kindly.
> *** Genuinely rich *** Faithful talent *** Sharing success
>
> On Wednesday, January 16, 2019 3:09 PM, "gilberto.castillo@xxxxxxxxx"
> <gilberto.castillo@xxxxxxxxx> wrote:
>
> Hello
>
> You may to use oracle_fdw
>
> El 2019-01-16 15:05, Pepe TD Vo escribió:
>> I am able to download the ora2pg but I don't understand how it
>> install. According to the document I found on net that yum install
>> perl-DBD, perl-dev, and perl-CPAN and all
>> oracle-instantclient18.3-sqlplus-18.3.0.0.0-1.x86_64.rpm,
>> oracle-instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm,
>> oracle-instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm,
>> oracle-instantclient18.3-devel-18.3.0.0.0-1.x86_64.rpm,
>> oracle-instantclient18.3-devel-18.3.0.0.0-1.x86_64.rpm.
>>
>> * I can't find the ora2pg18.2 on gzip or zip but bz2. With this
> file
>> I can't unzip it because the server didn't have this feature. Can I
>> use ora2pg.19.1.tar.gz instead of version 18?
>> * Where should I install ora2pg, in the oracle db server or
> postgres
>> db server?
>>
>> thank you for your inputs.
>>
>> v/r,
>>
>> Bach-Nga
>>
>> No one in this world is pure and perfect. If you avoid people for
>> their mistakes you will be alone. So judge less, love and forgive
>> more.
>> To call him a dog hardly seems to do him justice though in as much
> as
>> he had four legs, a tail, and barked, I admit he was, to all outward
>> appearances. But to those who knew him well, he was a perfect
>> gentleman (Hermione Gingold)
>> **Live simply **Love generously **Care deeply **Speak kindly.
>> *** Genuinely rich *** Faithful talent *** Sharing success
>>
>> On Friday, January 11, 2019 11:42 AM, Shreeyansh Dba
>> <shreeyansh2014@xxxxxxxxx> wrote:
>>
>> This site works for us, there might be a security restriction at
> your
>> end.
>>
>> Thanks & Regards,
>> SHREEYANSH DBA TEAM
>> www.shreeyansh.com [2]
>>
>> On Fri, Jan 11, 2019 at 10:04 PM Pepe TD Vo <pepevo@xxxxxxxxx>
> wrote:
>>
>>> Yes, I need migrate all the objects including tables, functions,
>>> triggers, procedures from Oracle to Postgres. Oracle is on one
>>> server and Postgres is on another server.
>>>
>>> https://ora2pg.darold.net/documentation.html [1]doesn't work. "
>>>
>>> THIS SITE CAN’T BE REACHED
>>>
>>> ORA2PG.DAROLD.NET [1] took too long to respond.
>>>
>>> Try:"
>>>
>>> thank you.
>>>
>>> Bach-Nga
>>>
>>> No one in this world is pure and perfect. If you avoid people for
>>> their mistakes you will be alone. So judge less, love and forgive
>>> more.
>>> To call him a dog hardly seems to do him justice though in as much
>>> as he had four legs, a tail, and barked, I admit he was, to all
>>> outward appearances. But to those who knew him well, he was a
>>> perfect gentleman (Hermione Gingold)
>>> **Live simply **Love generously **Care deeply **Speak kindly.
>>> *** Genuinely rich *** Faithful talent *** Sharing success
>>>
>>> On Friday, January 11, 2019 11:31 AM, Shreeyansh Dba
>>> <shreeyansh2014@xxxxxxxxx> wrote:
>>>
>>> Hi,
>>> You can use ora2pg which is one of the best tool for data migration
>>> from Oracle to PostgreSQL.
>>>
>>> https://ora2pg.darold.net/documentation.html
>>>
>>> Thanks & Regards,
>>> SHREEYANSH DBA TEAM
>>> www.shreeyansh.com [2]
>>>
>>> On Fri, Jan 11, 2019 at 9:53 PM Pepe TD Vo <pepevo@xxxxxxxxx>
> wrote:
>>>
>>>> Hi Experts,
>>>>
>>>> Is there a best tool for me to copying data from Oracle to
>>>> PostgreSQL?
>>>> The Oracle db named is Cidr and had a few schemas, each schemas
>>>> owned their own tables, procedures, triggers, functions. If I
>>>> create a database on Postgres, how do I copy all schemas from
>>>> Oracle? Or each schema will become one of the postgreSQL database?
>>>>
>>>> thank you for your helps.
>>>>
>>>> v/r,
>>>>
>>>> Bach-Nga
>>>>
>>>> No one in this world is pure and perfect. If you avoid people for
>>>> their mistakes you will be alone. So judge less, love and forgive
>>>> more.
>>>> To call him a dog hardly seems to do him justice though in as much
>>>> as he had four legs, a tail, and barked, I admit he was, to all
>>>> outward appearances. But to those who knew him well, he was a
>>>> perfect gentleman (Hermione Gingold)
>>>> **Live simply **Love generously **Care deeply **Speak kindly.
>>>> *** Genuinely rich *** Faithful talent *** Sharing success
>>
>>
>>
>> Links:
>> ------
>> [1] http://ora2pg.darold.net/
>
>> [2] http://www.shreeyansh.com/
>
>
>
> Links:
