ORA-02304: Invalid Object Identifier Literal While Doing Impdp
ANKUSH 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.