Re: import dump

Posted by ErmanArslansOracleBlog on Mar 09, 2017; 7:25am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/import-dump-tp2317p2322.html

You see the cause right?

It says the problem is caused by the OID. Type are exported with OID, but they can not be imported ,becauase OID should be unique in the database.
So I guess you are doing this export-import in 1 database (with different schemas)

Solution: You can use the Import DataPump parameter TRANSFORM which enables you to alter object creation DDL for the types. The value N (= No) for the transform name OID implies that a new OID is assigned.