Home » RDBMS Server » Server Utilities » Will data pump preserve the order specified in the tables list ?
Will data pump preserve the order specified in the tables list ? [message #350600] Thu, 25 September 2008 10:11 Go to next message
user0903160210
Messages: 2
Registered: September 2008
Junior Member
Hi,

I am trying import data to a target data base using data pump and those tables have some referential constraints defined and for which i am getting following error.

integrity constraint () violated - parent key not found.

Then i specified order(all parent tables first & then child tables), but data pump is taking its own order...

Will data pump preserve the order specified in the tables list ?

Could some one please help in this regard...

Thanks in advance..
Re: Will data pump preserve the order specified in the tables list ? [message #350653 is a reply to message #350600] Thu, 25 September 2008 16:40 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above

Try This...

1. Import with this parameter

CONTENT=METADATA_ONLY 


2. Now Disable all constraints in your schema.

3. Again import with this parameter

CONTENT= DATA_ONLY, TABLE_EXISTS_ACTION = SKIP 


4. Now Enable all constraints in your schema.


Babu
Re: Will data pump preserve the order specified in the tables list ? [message #350687 is a reply to message #350653] Thu, 25 September 2008 22:35 Go to previous messageGo to next message
user0903160210
Messages: 2
Registered: September 2008
Junior Member
Hi Babu,

I want to import only data...

Apart from disabling & enabling constraints, is there is any other way that we can resolve this issue...

any options available in data pump to specify order of import...?

Regards,
puru

[Updated on: Thu, 25 September 2008 22:42]

Report message to a moderator

Re: Will data pump preserve the order specified in the tables list ? [message #350734 is a reply to message #350687] Fri, 26 September 2008 01:24 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Try this.

1. Disable all constraints from your schema.

2. Import with this parameter

...CONTENT=DATA_ONLY , TABLE_EXISTS_ACTION = SKIP , EXCLUDE = CONSTRAINT , EXCLUDE=REF_CONSTRAINT 


3. Now manually enable all constraints..

This should be work; But before try in development environment.

Thank you in advance.

Babu

[Updated on: Fri, 26 September 2008 01:28]

Report message to a moderator

Previous Topic: How to Export only packages and procedures
Next Topic: Silent Export
Goto Forum:
  


Current Time: Sat Dec 03 07:43:42 CST 2016

Total time taken to generate the page: 0.12474 seconds