Printable View
Hi, all
I have two db, A and B. A and B has the same tables and A has the data in the tables. B's tables are empty. A and B's tables have the same columns but in different order. That is why I can not use import and export. Is there any way I can export the data from A to a text file and edit it and insert back into B? Thanks for help.
It is REALLY easy if you use SQL-Worksheet or TOAD. You use those? Those GUIs will take a table and save it as a .csv file.
Basically, send the table from DB A to a .CSV file. From there you can use SQLLOADER to insert the data to DB B with a .ctl file to position your column inserts.
Questions?
- Magnus
If you don't have those GUIs, you can also you the export/import functionality provided by Oracle.