Login  Register

Re: impdp error

Posted by ErmanArslansOracleBlog on Oct 26, 2016; 11:42am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/impdp-error-tp1444p1446.html

Did you run this import multiple times? I m asking this, because some of the records may be left there and that's why reimporting may create duplicate records.

The error is obvious. There are duplicate records in the columns on which the impdp tries to create unique index (unique index requires unique records) If that's the case, please delete the imported schema, recreate it and then reimport.
Also, ensure that no application is operating on the table on which the impdp tries to create unique indexes.