ORA-39117: Type needed to create table is not included in this operation

tolywang發表於2013-04-10
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39117: Type needed to create table is not included in this operation.
Failing sql is:
CREATE TABLE "TEST1"."TAB_BASECONCEPTS"("ID" NUMBER, "ENTITY"
"TEST1"."T_ENTITY" ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS
LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE
"USERS" NESTED TABLE TREAT("ENTITY" AS "T_BASECONCEPT")."PROPERTIES" STORE
AS "NESTEDTABLE1"(PCTFREE 10 PCTUSED 40 INITRANS
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

The types involved in the problematic create table statement are created
successfully during impdp execution. So, the error ORA-39117 should not be
reported.


在10.2 版本的解決方法: 


In Oracle10g Release 2 (10.2.0.x.y), there is no need to pre-create the object types and the tables in the target schema. Instead, you can use the Import DataPump parameter TRANSFORM. which enables you to alter object creation DDL for the types. The value N (= No) for the transform. name OID implies that a new OID is assigned. Example:

impdp system/manager DIRECTORY=my_dir DUMPFILE=expdp_u1.dmp LOGFILE=impdp_u1.logREMAP_SCHEMA=u1:u2 TRANSFORM=oid:n

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-767646/,如需轉載,請註明出處,否則將追究法律責任。

相關文章