Exporting specific data from DB into another DB

[hmckillop]

Hello,

I have been tasked with "migrating" data from one Oracle DB to another Oracle DB of same schema.
This DB is used as a multi-tenant seperated by a logical column (e.g. Organisation ID).

I am now being asked to move data from this DB into another DB in a different location - as such I need to extract specific inter dependent data (e.g. 50 tables, but in some way linked via organisation id)

has anyone done this before, if so how and what tools did you use?

Thanks in advance.



"I'm living so far beyond my income that we may almost be said to be living apart

 

[Beilstwh]

I would use the datapump utility expdp to export all the tables with their structure, data, indexes, and constraints. Then use the impdp to load it into the new database.

Bill
Lead Application Developer
New York State, USA