From: | Pepe TD Vo <pepevo(at)yahoo(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org, Thomas Kellerer <shammat(at)gmx(dot)net> |
Subject: | Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL |
Date: | 2020-04-20 14:02:53 |
Message-ID: | 172687860.2288957.1587391373846@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Mr. Kellerer,
we can access Oracle table within Postgres? How? Need to create a database link and/or how can both talk to each other?
My data is from production, can turn off the foreign key. Is there a way to copy data from Oracle to Postgres faster? Should I export the Oracle data table via dump file as text/csv and insert it into Postgres? Can we use an oracle dump file?
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 Monday, April 20, 2020, 09:28:18 AM EDT, Thomas Kellerer <shammat(at)gmx(dot)net> wrote:
Prashant Kulkarni schrieb am 20.04.2020 um 13:53:
> Hi Team,
>
> Please can you let me know the menthds/tools/approches to export
> large amount of data (TBs) present in the schemas into the
> CSV/delimated format as we have to import that into PostgreSQL
> later.
>
> I tried for options like SQL Developer/Toad but those are not
> feasible for vast data size, these tool are OK for GBs of data to
> export.
>
> Kindly let me know if you have any solution to complete this task.
Using a foreign table would remove the need to dump and transfer
the data to begin with.
Then you could access the Oracle table directly from within Postgres:
insert into some_table (...)
select ...
from oracle_fdw_table;
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2020-04-20 14:39:39 | Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL |
Previous Message | Thomas Kellerer | 2020-04-20 13:27:55 | Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL |