EBS R12.1.3 : import of EBS database has some errors.
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: