Re: Export/Import of Userdefined Objects

Similar question was raized before. This thread should help you.

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=42ffa8fa.0209091141.3b6f0860%40posting.google.com

• Jusung Yang

"Sabine.Buechel" <Sabine.Buechel_at_innosystec.de> wrote in message news:<arkvqu$47c$00$2_at_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 - 11:07:23 CST