ORA-39117: Type needed to create table is not included in this operation
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
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博客 ” ，链接：https://blog.itpub.net/35489/viewspace-767646/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
