| Datapump import and Referential Integrity constraints [message #555387] |
Wed, 23 May 2012 12:50  |
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 #555419 is a reply to message #555395] |
Thu, 24 May 2012 01:31  |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
