import dump

[Roshan]

Hi Erman,

I have performed a dump import on a schema CBS_TT_CORE. I dropped the schema and recreated it before import.

Please find attached the log file.
mtcore.txt

As shown below, the TYPE on source schema is different than that on target schema

Capture.PNG

What can you suggest.

Thanks,

Roshan

[ErmanArslansOracleBlog]

Read this : DataPump Import Of Object Types Fails With Errors ORA-39083 ORA-2304 Or ORA-39117 ORA-39779 (Doc ID 351519.1)

[ErmanArslansOracleBlog]

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.