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 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

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


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms