During the import using impdp, several errors occured:ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literalFailing sql is:CREATE TYPE "ECMST2"."TX_ECMS_EXCEPTION" OID 'EAF92B3811A604E4E0430A3C040104E4' as object
(
error_code varchar2(30), --Error business code
result_code number, --Result code returned by API - 8 - error, 4 - warning, 255 - unhandled exception
error_desc varchar2(4000), --Error description
placeholders_desc varchar2(4000), --Description of placeholders used in error_desc
sql_code number,
The problem is, that import is trying to craete a new object with the same OID.
to solve the problem, the TRANSFORM=OID:n has to be added to the impdp command:
impdp directory=IMPORT dumpfile=ecms_test2.dmp logfile=ecms_t2_imp.log schemas=ECMS remap_schema=ECMS:ECMST2 remap_tablespace=USERS:ECMS_T2 transform=OID:n
ORA-02304: invalid object identifier literalFailing sql is:CREATE TYPE "ECMST2"."TX_ECMS_EXCEPTION" OID 'EAF92B3811A604E4E0430A3C040104E4' as object
(
error_code varchar2(30), --Error business code
result_code number, --Result code returned by API - 8 - error, 4 - warning, 255 - unhandled exception
error_desc varchar2(4000), --Error description
placeholders_desc varchar2(4000), --Description of placeholders used in error_desc
sql_code number,
The problem is, that import is trying to craete a new object with the same OID.
to solve the problem, the TRANSFORM=OID:n has to be added to the impdp command:
impdp directory=IMPORT dumpfile=ecms_test2.dmp logfile=ecms_t2_imp.log schemas=ECMS remap_schema=ECMS:ECMST2 remap_tablespace=USERS:ECMS_T2 transform=OID:n