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部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-767646/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- create table of mysql databaseMySqlDatabase
- User defined table type and table valued parameters
- table type usage sample:
- create a partition table using a exsit table
- Oracle Create Table as SelectOracle
- create table if not exists Waiting for table metadata lockAI
- MySQL5.6 create table原理分析MySql
- sqlserver不能直接create table as select ......SQLServer
- create table進階學習(一)
- create table進階學習(三)
- create table進階學習(四)
- MySQL的create table as 與 like區別MySql
- VBA從Excel中生成Oracle create tableExcelOracle
- create table進階學習系列(八)
- create table進階學習系列(五)
- create table進階學習系列(七)
- create table進階學習系列(九)
- CREATE TABLE AS SELECT(CAST)(二)-ConceptAST
- Nobody is needed
- plsql_列集_collection_type is table ofSQL
- 11gr2增強CREATE OR REPLACE TYPE功能
- use azure data studio to create external table for oracleOracle
- create table之storage選項initial和其它
- T-SQL的CREATE TABLE語法(下)SQL
- T-SQL的CREATE TABLE語法(上)SQL
- create table進階學習(二)_全域性臨時表_global temporary table
- Oracle11gr2新增CREATE OR REPLACE FORCE TYPE功能Oracle
- oracle 19c 無法create table解決Oracle
- How to Quickly Create a Copy of a Table using Transact-SQLUISQL
- dual表與create table語句的關係
- CREATE TABLE AS SELECT(CAST)(一)-ORA-1652AST
- NOARCHIVE模式CREATE TABLE不記錄日誌呀Hive模式
- create table進階學習系列(十一)之cluster
- Inheritance with EF Code First: Part 2 – Table per Type (TPT)
- MM-step to create a new material type/valuation cloass//account category referenceGo
- oracle10.2.0.4_create table_constraint_indexOracleAIIndex
- CREATE INDEX index1 ON table1(col1)Index
- 資料庫審計(create/alter/drop table、user、tablespace)資料庫