My Oracle Support Banner

Impdp : ORA-39117: Type Needed To Create Table Is Not Included In This Operation (Doc ID 2405951.1)

Last updated on JANUARY 16, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

During full IMPDP, the following error is reported:

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

CREATE TABLE "<SCHEMA_NAME_SPATIAL>"."<TABLE_NAME>" ("<COLUMN1>" NUMBER(20,0) NOT NULL ENABLE,
"<COLUMN2>" NUMBER NOT NULL ENABLE, "<COLUMN3>" "MDSYS"."SDO_GEOMETRY" , "<COLUMN4>" NVARCHAR2(255),
"<COLUMN5>" NUMBER(20,0) NOT NULL ENABLE, "<COLUMN6>" NVARCHAR2(254), "<COLUMN7>" NVARCHAR2(254), "<COLUMN8>" NVARCHAR2(254),
"<COLUMN9>" NVARCHAR2(254), "<COLUMN10>" NVARCHAR2(254), "<COLUMN11>" TIMESTAMP (6)) SEGMENT CREATION IMMEDIATE PCTF

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.