From time to time our backups were failing on the ORA-00245 error
0 Comments
ORA-39083 - Object type TYPE failed to create. ORA-02304: invalid object identifier literal8/18/2015 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 |
NiscoHere, in this section, I will write some usefull thing, I have learned during my everyday work. Archives
August 2015
Categories |