Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import of data using impdp fails because of missing dependencies

957715Aug 24 2012 — edited Sep 2 2012

Hi,

I need to export a subset of a table and import it in another Oracle instance which already contains all required namespaces, tables, constraints, procedures, ... All tables of the new instance are empty. The export using expdp works pretty well but when I try to import the data in the other instance using impdp tool it fails because there are dependencies (foreign keys to other tables which were not exported) missing.

Is there any option to force expdp tool to export all required dependencies as well (so in my case, if the table I want to export called 'table1' has a foreign key to 'table2', all the required rows of 'table2' should be exported too and if 'table2' has a foreign key to 'table3', also these rows should be exported)? If not, what else could I do to solve the problem?

Thanks in advance for any help!

Peter