datapump: ORA-02304: invalid object identifier literal

During datapump import, there were errors with object ID (OID). This probably coming from another user who created the datapump export with transform=OID:y. In order to get the datapump import going, simply insert the clause of transform=OID:n since the default is transform=OID:y

Failing sql is:
CREATE TYPE "TRD"."SETOF_XORP_LOCKED_RESOURCES_SP"   OID 'B0DDDACF8F8G1137E0400D0AC4181435' AUTHID DEFINER AS OBJECT(moref VARCHAR2(254),vc_id RAW(16),cpu_required NUMBER(10,0),mem_required NUMBER(10,0))
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "TRD"."SETOF_XKI_ID_MO_DEPLOY_COUNT"   OID 'B0DDDACF8F961137E9400D0AC4181435' AUTHID DEFINER AS OBJECT(vs_id RAW(16),root_dir_id NUMBER(10,0),ms_count NUMBER(10,0))
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "TRD"."SETOF_MO_ID"   OID 'B0DDDACF8FA81137E0400D0AC4181435' AUTHID DEFINER AS OBJECT(ms_id RAW(16))
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "TRD"."SETOFMSKOCKEDRXSOURCESSPSET"   OID 'B0DDDACF8F9C1137E0405D0AC4181435' AS TABLE OF setof_ms_locked_resources_sp
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "TRD"."SETOFRPLTCKEDEESOURCESSPSET"   OID 'B0DDD6ACF8FA01137E000D0AC4181435' AS TABLE OF setof_rp_locked_resources_sp
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal


impdp TXD@txorcl DIRECTORY=tx_dump dumpfile=tx_export_6300414.dmp REMAP_SCHEMA=TXDU:TXD remap_tablespace=TXDU_DATA:TXD_DATA TRANSFORM=oid:n

imp instead of impdp was provided causing ORA-39000

In this case, I was told a "datapump" export file was provided. However, when I performed the datapump import, it failed with ORA-39000. From my best knowledge
only couple things could trigger this error. There are either corrupted datapump import file or user performed an import with "imp" instead of datapump. Datapump file
corruption usually resulted of zip being trimmed during ftp or uploading.


Importing with "impdp" will trigger the following error.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39143: dump file "/backup/RD_20140217-2.dmp" may be an original export dump file


imp RDU file=/home/oracle/downloads/CHGPR_20140217.dmp full=n buffer=2000000 commit=y ignore=y log=/home/oracle/downloads/imp_RDU_20140217.log