Oracle Solution for Error ora-02304

ORA-02304: invalid object identifier literal

What triggered the Error:

An attempt was made to enter an object identifier literal for CREATE TYPE that is either: *- not a string of 32 hexadecimal character. *- an object identifier that already identifies an existing objec. *- an object identifier different from the original object identifier already assigned to the typ.

What should we do to fix it:

Do not specify the object identifier clause or specify a 32 hexadecimal-character object identifier literal that is unique or identical to the originally assigned object identifier. Then retry the operation.