Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Export/Import of Userdefined Objects
Hallo All,
have problems with the Import of a Dump that was generated on a schema
having lot of userdefined Objects in it (Import in a schema on the same DB;
grants: resource,connect,dba).
Always get the Error:
IMP-00017: following statement failed.....
"CREATE TYPE "USER_TYPE_1" TIMESTAMP '2001-03-13:14:14:14' OID
'7F63CF3FBA33BA59E030A8C0610304AO' as OBJECT ( "version VARCHAR2(100),
.........)"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal ----> what says:
Cause: An attempt was made to enter an object identifier literal for CREATE
TYPE that is either:
Not a string of 32 hexadecimal characters
An object identifier that already identifies an existing object
An object identifier different from the original object identifier already
assigned to the type
Action: 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.
How can I manage this problem?
Using ORACLE 8.1.7 on SuSE Linux 7.0 (i386); Linux 2.2.16
Thanks in advance
S.Buechel Received on Fri Nov 22 2002 - 04:12:27 CST
![]() |
![]() |