Hi Experts,
We have taken 200GB schema backup in production and while importing in pre-prod,
Getting error like this,Kindly help on this ( I have compared the dumps on both sizes are same)
ORA-02369: internal number in header in file /metorauat/metora204_bkp/expdp_METNSURE__03.dmp is not valid
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "METNSURE"."PETTYCASH_VOUCHER_DOC" 11.23 GB 55734 rows
ORA-31693: Table data object "METNSURE"."METCLAIM_EMPLOYEEMASTER_HIST" failed to load/unload and is being skipped due to error:
ORA-39183: internal error -16 ocurred during decompression phase 2
ORA-31693: Table data object "METNSURE"."EXPENSE_COMPLIANCE_INFO" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-02373: Error parsing insert statement for table "METNSURE"."EXPENSE_COMPLIANCE_INFO".
ORA-00600: internal error code, arguments: [kpodpbis failure2], [6502], [ORA-06502: PL/SQL: numeric or value error
LPX-00007: unexpected end-of-file encountered
ORA-06512: at "SYS.KUPD$DATA", line 4186
ORA-06512: at line 1
], [], [], [], [], [], [], [],
ORA-31693: Table data object "METNSURE"."MAILS_TOBE_PUSHED" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-02368: the following file is not valid for this load operation
ORA-02369: internal number in header in file /metorauat/metora204_bkp/expdp_METNSURE__03.dmp is not valid
ORA-31693: Table data object "METNSURE"."EXPENSE_TRANS_DETAILS" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data