Home » RDBMS Server » Server Utilities » expdp&impdp about object OID??
expdp&impdp about object OID?? [message #200915] Wed, 01 November 2006 21:29 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #201004 is a reply to message #200923] Thu, 02 November 2006 04:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
A little search would always help Smile
http://www.orafaq.com/forum/m/165975/42800/?srch=OID#msg_165975
Re: expdp&impdp about object OID?? [message #201008 is a reply to message #201004] Thu, 02 November 2006 04:12 Go to previous messageGo to next message
linyumin
Messages: 13
Registered: August 2006
Location: Taiwan Taipei
Junior Member
Mahesh Rajendran wrote on Thu, 02 November 2006 18:05
A little search would always help Smile
http://www.orafaq.com/forum/m/165975/42800/?srch=OID#msg_165975


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

Re: expdp&impdp about object OID?? [message #201011 is a reply to message #201008] Thu, 02 November 2006 04:19 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Yup. I forgot the that you are using IMPDP and not IMP.
Previous Topic: 10.1.0.4 Windows - Datapump across machines
Next Topic: SQL Trace
Goto Forum:
  


Current Time: Tue Jul 02 16:40:28 CDT 2024