Home » RDBMS Server » Server Utilities » imp dump with object type ORA-02304
icon8.gif  imp dump with object type ORA-02304 [message #279397] Thu, 08 November 2007 01:39 Go to next message
harry.oracle
Messages: 2
Registered: November 2007
Junior Member
hi!

does anyone crowned with success how to import a dump with object type and avoided ORA-02304 by using the parameter TOID_NOVALIDATE?
or is there a bug?

thnx a lot
Re: imp dump with object type ORA-02304 [message #279451 is a reply to message #279397] Thu, 08 November 2007 09:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
02304, 00000, "invalid object identifier literal"
// *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.
Re: imp dump with object type ORA-02304 [message #279465 is a reply to message #279451] Thu, 08 November 2007 10:59 Go to previous message
harry.oracle
Messages: 2
Registered: November 2007
Junior Member
how do i export a user, e.g. scott, with an object created by
"CREATE TYPE mytype AS OBJECT ( val number );"
and import the dump to another user, e.g. scott2, in the same instance, without getting ORA-02304?

please help

[Updated on: Thu, 08 November 2007 11:01]

Report message to a moderator

Previous Topic: impdb error
Next Topic: Sql Loader issue
Goto Forum:
  


Current Time: Wed Dec 25 00:01:18 CST 2024