OraFAQ Forum: Server Utilities » Export data ordered and organized!

Home » RDBMS Server » Server Utilities » Export data ordered and organized! (Oracle 11gR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export data ordered and organized! [message #533375]

Tue, 29 November 2011 12:27

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!

Report message to a moderator

Re: Export data ordered and organized! [message #533377 is a reply to message #533375]

Tue, 29 November 2011 12:42

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

This is standard functionaility of Datapump export or the old exp utility.

Report message to a moderator

Re: Export data ordered and organized! [message #533378 is a reply to message #533377]

Tue, 29 November 2011 12:44

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!

Report message to a moderator