Errors in impdp while copying xmltype

From: Upendra nerilla <nupendra_at_hotmail.com>
Date: Thu, 25 May 2017 15:47:45 +0000
Message-ID: <BN6PR1001MB2162D579488F4B4BCDA3B75BD8FF0_at_BN6PR1001MB2162.namprd10.prod.outlook.com>



Hello everyone -

I am trying to migrate a schema from oracle 11.2 to 12.2. I do have a few tables that have XMLTYPE columns.

There are no errors during export and while importing all the tables with XMLTYPE columns are failing..

Any help or pointers are appreciated.

Here is an example error:

ORA-39083: Object type TABLE:"AEC_173DA6E"."AEI_TR_5086348" failed to create with error: ORA-00904: : invalid identifier
Failing sql is:
CREATE TABLE "AEC_173DA6E"."AEI_TR_5086348" ("ID" NUMBER NOT NULL ENABLE, "RM_5086348_ID" NUMBER NOT NULL ENABLE, "CLIENT_ID" NUMBER NOT NULL ENABLE, "TYPE" NUMBER NOT NULL ENABLE, "EFFECTIVE_F ROM" TIMESTAMP (6) NOT NULL ENABLE, "EFFECTIVE_TO" TIMESTAMP (6) NOT NULL ENABLE, "SYSTEM_DATE_FROM" TIMESTAMP (6) NOT NULL ENABLE, "SYSTEM_DATE_TO" TIMESTAMP (6) NOT NULL ENABLE, "UPDATED_BY_U SER_ID" NUMBER, "UPDATED_BY_ORIGINAL_USER_ID" NUMBER, "UPDATED_BY_SESSION_ID" NUMBER, "UPDATED_BY_LOAD_ID" NUMBER, "UPDATED_BY_WORKFLOW_ID" NUMBER, "UPDATED_BY_WORKFLOW_VERSION_ID" NUMBER, "UPD ATED_BY_BR_ID" NUMBER, "F_84480045" "XMLTYPE", "F_84489428" "XMLTYPE", "F_84440002" "XMLTYPE", "F_84435984" "XMLTYPE", "F_84509629" "XMLTYPE", "F_84502918" "XMLTYPE", "F_84435788" "XMLTYPE", "F _84469108" "XMLTYPE", "F_84477909" "XMLTYPE", "F_84528590" "XMLTYPE", "F_84533802" "SYS"."XMLTYPE" ) SEGMENT CREATION IMMEDIATE 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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "A LPHA_DATA" VARRAY "SYS_NC00078$"."values"."value" STORE AS TABLE "SYS_NTPIMsnis0FyjgU6QKggpHeA=="(PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEX TENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPAC Thanks much in advance

-Upendra

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 25 2017 - 17:47:45 CEST

Original text of this message