Home » RDBMS Server » Server Utilities » Export data ordered and organized! (Oracle 11gR2)
Export data ordered and organized! [message #533375] Tue, 29 November 2011 12:27 Go to next message
aucrun
Messages: 114
Registered: February 2011
Senior Member
Hi,

I was wondering if there is any way to export an Oracle database organized in manner that, both tables and constraints would be exported in the correct order.

An easy sample:
- An database with 2 tables, with constraints between them. Table 1 has a FK on Table 2.

Is it possible to export both structure and data regarding the constraints, resulting in an script that makes it possibly to import it in a way that would not give me problems about constraints?


Thanks!
Re: Export data ordered and organized! [message #533377 is a reply to message #533375] Tue, 29 November 2011 12:42 Go to previous messageGo to next message
John Watson
Messages: 8137
Registered: January 2010
Location: Global Village
Senior Member
This is standard functionaility of Datapump export or the old exp utility.
Re: Export data ordered and organized! [message #533378 is a reply to message #533377] Tue, 29 November 2011 12:44 Go to previous messageGo to next message
aucrun
Messages: 114
Registered: February 2011
Senior Member
But, does that exports data regarding relationships between tables?

Does it notices that some table is a child of another one and therefore exports first the parent one?

Thanks!
Re: Export data ordered and organized! [message #533379 is a reply to message #533378] Tue, 29 November 2011 12:46 Go to previous messageGo to next message
Michel Cadot
Messages: 66807
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No and it does not care, it creates the foreign keys after importing the data.

Regards
Michel

[Updated on: Tue, 29 November 2011 12:46]

Report message to a moderator

Re: Export data ordered and organized! [message #533380 is a reply to message #533379] Tue, 29 November 2011 13:10 Go to previous message
aucrun
Messages: 114
Registered: February 2011
Senior Member
Ok, thanks!
Previous Topic: Oracle 9i
Next Topic: migrate table from 10g xe to oracle 9i
Goto Forum:
  


Current Time: Tue Jan 28 19:31:44 CST 2020