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)
On Monday, April 20, 2020, 09:28:18 AM EDT, Thomas Kellerer <shammat@gmx.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;
