expdp&impdp about object OID?? [message #200915] |
Wed, 01 November 2006 21:29 |
linyumin
Messages: 13 Registered: August 2006 Location: Taiwan Taipei
|
Junior Member |
|
|
I've read the oracle document about 10g new utilities
about impdp's option transform=OID
OID - If the value is specified as n, the assignment of the exported OID during the
creation of object tables and types is inhibited. Instead, a new OID is assigned.
This can be useful for cloning schemas, but does not affect referenced objects. The
default value is y.
I want to expdp A schema from a database and impdp remap_schema to B schema on same database
I know that all objects' OID should carry an unique string,so when I imppdp~~I take the impdp's option "transform=OID:y"
But it doesn't work!!!
I still get many error like below
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "POC"."VA_FLOAT" OID 'A696AAD4D9804F5C8BDCEE88DF42B3EF' is varray(106) of float
|
|
|
Re: expdp&impdp about object OID?? [message #200921 is a reply to message #200915] |
Wed, 01 November 2006 22:29 |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |
|
|
OID - If the value is specified as n, the assignment of the exported OID during the creation of object tables and types is inhibited. Instead, a new OID is assigned. This can be useful for cloning schemas, but does not affect referenced objects. The default value is y.
ORA-39083: Object type string failed to create with error: string Failing sql is: string
Cause: Examine original error code to determine actual cause
Action: Original error code will contain more information
ORA-02304: 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
Hope this Helps.
Mohammad Taj
[Updated on: Wed, 01 November 2006 22:31] Report message to a moderator
|
|
|
Re: expdp&impdp about object OID?? [message #200923 is a reply to message #200915] |
Wed, 01 November 2006 22:47 |
linyumin
Messages: 13 Registered: August 2006 Location: Taiwan Taipei
|
Junior Member |
|
|
I'm a pig head~~
It should be taken as "transform=oid:n",
then all imported objects would be assigned a new OID instead of inhibiting the old OID from exported objects
|
|
|
|
Re: expdp&impdp about object OID?? [message #201008 is a reply to message #201004] |
Thu, 02 November 2006 04:12 |
linyumin
Messages: 13 Registered: August 2006 Location: Taiwan Taipei
|
Junior Member |
|
|
I've searched this article on this forum~~
but he Manually extract the DDL of those objects that failed (from the logfile) and re-run again on target
if you take the option "transform=oid:n" when impdp,then you don't worry about the problem even if there're thousands of objects
But~~the OID option for transform parameter is supported only on 10.2
[Updated on: Thu, 02 November 2006 04:14] Report message to a moderator
|
|
|
|