Home » RDBMS Server » Server Utilities » Datapump import and Referential Integrity constraints (Oracle 11.2.0.3 Linux c86_64)
Datapump import and Referential Integrity constraints [message #555387] Wed, 23 May 2012 12:50 Go to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
I am using Datapump import using database link to import an entire schema from another Server but it gives issues with constraints.I tried to first only import the metadata and then disable the constraints and import data and enable constraint but in this case the temp tablespace keeps filling up and i am out of space.
Is there any method to do a full import including constraints and indexes

Regards
Re: Datapump import and Referential Integrity constraints [message #555388 is a reply to message #555387] Wed, 23 May 2012 12:52 Go to previous messageGo to next message
Michel Cadot
Messages: 67884
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
it gives issues with constraints


Which ones?

Copy and paste your session.

And DataPump is NOT a database backup.

Regards
Michel
Re: Datapump import and Referential Integrity constraints [message #555390 is a reply to message #555388] Wed, 23 May 2012 13:07 Go to previous messageGo to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
Yes I know Datapump is not for Backup but this can be used for database upgrades when there is no choice of in place upgrade.
Re: Datapump import and Referential Integrity constraints [message #555391 is a reply to message #555390] Wed, 23 May 2012 13:24 Go to previous messageGo to next message
Michel Cadot
Messages: 67884
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Yes I know Datapump is not for Backup

So do not post your question in Backup forum.
And post what is requested.

Regards
Michel
Re: Datapump import and Referential Integrity constraints [message #555395 is a reply to message #555391] Wed, 23 May 2012 16:26 Go to previous messageGo to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
Following error reported

RA-02270: no matching unique or primary key for this column-list
Failing sql is:
ALTER TABLE "TESTOOL"."TEST_LANDSCAPE_DETAIL_QKIT" ADD CONSTRAINT "PRLD_PRLM_FK" FOREIGN KEY ("PRLD_PRLM_FK") REFERENCES "PI OOL"."TEST_LANDSCAPE_MASTER_QKIT" ("PRLM_PK") DISABLE
ORA-39083: Object type REF_CONSTRAINT failed to create with error:

[Updated on: Wed, 23 May 2012 16:34]

Report message to a moderator

Re: Datapump import and Referential Integrity constraints [message #555419 is a reply to message #555395] Thu, 24 May 2012 01:31 Go to previous messageGo to next message
Michel Cadot
Messages: 67884
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-02270: no matching unique or primary key for this column-list
 *Cause: A REFERENCES clause in a CREATE/ALTER TABLE statement
         gives a column-list for which there is no matching unique or primary
         key constraint in the referenced table.
 *Action: Find the correct column names using the ALL_CONS_COLUMNS
          catalog view

The problem is not in the foreign key it is that the referenced primary/unique key does not exist.

Regards
Michel

[Updated on: Thu, 24 May 2012 01:32]

Report message to a moderator

Re: Datapump import and Referential Integrity constraints [message #555621 is a reply to message #555419] Fri, 25 May 2012 09:06 Go to previous messageGo to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
I have checked with the source database and there are no duplicate rows but while doing a impdp using datalink it creates duplicate rows and its always same 2 records which are duplicated and the primary key cannot be created.
Re: Datapump import and Referential Integrity constraints [message #555624 is a reply to message #555621] Fri, 25 May 2012 09:20 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
file a bug report with Oracle Support.
nobody here can do anything for you.
Previous Topic: Faster impdp excluding Indexes and constraints
Next Topic: importing dumpfile
Goto Forum:
  


Current Time: Thu Jun 17 12:33:22 CDT 2021