Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TRANSFORM=SEGMENT_ATTRIBUTES,OID:N

Sunilqln-OracleMar 12 2008 — edited Mar 12 2008
Hi All,

In 10.2.02(linux) ,Can I use in the impdp command

TRANSFORM=SEGMENT_ATTRIBUTES,OID:N

If not,Can you suggest how can i use this.




While Importing the object types I am getting error



ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "DEV"."SPLIT_TBL" OID '3F980C862056C6A9E040578C9CDD4603' as table of varchar2(32767)
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE OR REPLACE TYPE D_M_MERGE_RESULT_TYPE AS OBJECT( party_number varchar2(30), party_name varchar2(360),country varchar2(60),party_id number,merge_status varchar2(100),reject_reason varchar2(1000),certification_level varchar2(30),duns_num varchar2(30),sic_code varchar2(30),total_sites NUMBER)
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "DEV"."D3_CDM_MERGE_RESULT_SET" OID '3FE2D1F3DC047089E040578C9CDD23A8' AS TABLE OF d3_cdm_merge_result_type



Regards,
sunil
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2008
Added on Mar 12 2008
#general-database-discussions
1 comment
2,162 views