Cannot Import Reference Partition Tables Get ORA-2261 ON DATAPUMP IMPORT
(Doc ID 1584356.1)
Last updated on SEPTEMBER 14, 2013
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.2]
Information in this document applies to any platform.
During datapump import you get similar errors:
CREATE TABLE "DT_TEMP"."AS_MARKET" ("ID" NUMBER(19,0) NOT NULL ENABLE, "HIBERNATE_VERSION" NUMBER(10,0) NOT NULL ENABLE,
"SETTLEMENT_INTERVAL" NUMBER(19,0) NOT NULL ENABLE, "ROW_SOURCE" VARCHAR2(20 BYTE), "ROW_QUALITY" VARCHAR2(20 BYTE), "R
OW_CREATED_BY" VARCHAR2(20 BYTE), "ROW_CREATED_DATETIME" TIMESTAMP (6), "ROW_CHANGED_BY" VARCHAR2(20 BYTE),
ORA-39083: Object type TABLE:"DT_TEMP"."DDS_MARKET" failed to create with error:
ORA-02261: such unique or primary key already exists in the table
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|