- 07 Dec, 2023
- 0 Comments
- 1 Min Read
ORA-02304: Invalid Object Identifier Literal While Doing Impdp
1 2 3 4 5 6 7 8 | 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.
1 2 3 4 5 | 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.