My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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
  Symptoms
  Cause
  Solution
  References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.