Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting specific data from DB into another DB

Status
Not open for further replies.

hmckillop

Programmer
Oct 30, 2001
1,540
GB
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top