OraFAQ Forum: Server Utilities » Will data pump preserve the order specified in the tables list ?

Home » RDBMS Server » Server Utilities » Will data pump preserve the order specified in the tables list ?

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

Will data pump preserve the order specified in the tables list ? [message #350600]

Thu, 25 September 2008 10:11

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..

Report message to a moderator

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

babuknb
Messages: 1736
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

Report message to a moderator

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

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

babuknb
Messages: 1736
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 22:16:10 CST 2024