Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Export/Import of Userdefined Objects

Export/Import of Userdefined Objects

From: Sabine.Buechel <Sabine.Buechel_at_innosystec.de>
Date: Fri, 22 Nov 2002 11:12:27 +0100
Message-ID: <arkvqu$47c$00$2@news.t-online.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US