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

Issue:

ORA-39117: Type needed to create table is not included in this operation. Failing sql is:
CREATE TABLE “MVDEMO2″.”CITIES_US” (“LOCATION” “MDSYS”.”SDO_GEOMETRY” , “CITY” VARCHAR2(42 BYTE), “STATE_ABRV” VARCHAR2(2 BYTE), “POP90” NUMBER, “RANK90” NUMBER) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 131072 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACH

 

Solution:
Some dependency objects are missed which are required for respective Dump files. Address the prerequisites and retry the import. Generally this is seen when importing Sample data provided by Oracle, in such cases Install/setup Oracle Example schemas and retry.

FYI:

For more information on “Installing Java, Spatial etc” you may refer the blog, “http://babumani.blogspot.com/2009/10/install-oracle-spatial-in-oracle-11g.html”

Advertisements
This entry was posted in OBIEE, Oracle Database. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s