Technology Stack - EBS (MOSC)

MOSC Banner

EBS R12.1.3 : import of EBS database has some errors.

edited Mar 9, 2016 4:01AM in Technology Stack - EBS (MOSC) 8 commentsAnswered

Hi,

We did a export for EBS database from 11.2.0.1   and imported it to 12.1.0.2 database.    During import some of the  tables failed to create .

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

CREATE TABLE "AMV"."AMV_MATCHING_QUEUE_TBL" ("Q_NAME" VARCHAR2(30 BYTE), "MSGID" RAW(16), "CORRID" VARCHAR2(128 BYTE), "PRIORITY" NUMBER, "STATE" NUMBER, "DELAY" TIMESTAMP (6), "EXPIRATION" NUMBER, "TIME_MANAGER_INFO" TIMESTAMP (6), "LOCAL_ORDER_NO" NUMBER, "CHAIN_NO" NUMBER, "CSCN" NUMBER, "DSCN" NUMBER, "ENQ_TIME" TIMESTAMP (6), "ENQ_UID" NUMBER, "ENQ_TID" VARCHAR2(30 BYTE), "DEQ_TIME" TIMESTAMP (6), "DEQ_UID" NUMBER

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center