ORA-02304: Invalid Object Identifier Literal While Doing Impdp

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 07 Dec, 2023
  • 0 Comments
  • 1 Min Read

ORA-02304: Invalid Object Identifier Literal While Doing Impdp

CREATE TYPE "TEST_CVGCM02"."TEST_TEST2" OID 'BE4C0AFD318A07CBE0443C4A923B4794' AS OBJECT
(
NAME varchar2(40),
AGE number(4),
ID number(5)
)
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal

Generally , at the time of import , we may get this error.

Login to database, Check whether that OID “BE4C0AFD318A07CBE0443C4A923B4794″ exists or not.

SQL> select owner,TYPE_NAME,TYPE_OID from dba_types where TYPE_OID='BE4C0AFD318A07CBE0443C4A923B4794';

OWNER TYPE_NAME TYPE_OID
------------------------------ ------------------------------ --------------------------------
PRODUCT TEST_SYSTEM BE4C0AFD318A07CBE0443C4A923B4794

As we can see that that another TYPE is already exists in the database which is using the same OID. So you need to create the type manually by using a new OID. Else drop the existing TYPE and try to import.

Alternatively, you can use the parameter transform=oid:n  during impdp.

Hope it Helps!