IMPDP Fails With ORA-39083, ORA-30645 When Importing External Table (Doc ID 1060085.1)

Last updated on DECEMBER 13, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 to 11.2.0.1 - Release: 11.2 to 11.2
Information in this document applies to any platform.

Symptoms

IMPDP fails with the following errors when importing an external table:

ORA-39083: Object type TABLE:"TITAN"."TN_FORM_OF_PYMNT_EXT" failed to create with error:
ORA-30645: reject limit out of range
Failing sql is:
CREATE TABLE "TITAN"."TN_FORM_OF_PYMNT_EXT" ("ISSUE_DT" VARCHAR2(10 BYTE), "ALN_NBR" CHAR(3 BYTE), "TKT_NBR" CHAR(10 BYTE), "FOP_TYPE_KEY" VARCHAR2(4 BYTE), "FOP_SEQ_NBR" NUMBER(*,0), "FOP_TYPE" VARCHAR2(10 BYTE), "FOP_AMT" NUMBER(16,2), "RS_FOP_AMT" NUMBER(16,2), "FOP_ALN_NBR" CHAR(3 BYTE), "FOP_TKT_NBR" CHAR(10 BYTE), "RS_FOP_ALN_NBR" CHAR(3 BYTE), "RS_FOP_TKT_NBR

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