In this Document
| Symptoms |
|---|
| Cause |
|---|
| Solution |
|---|
Applies to:
Oracle Database – Enterprise Edition – Version 11.2.0.3 and later Information in this document applies to any platform.
Symptoms
The impdp TTS is fails with the following error message
Processing object type TRANSPORTABLE_EXPORT/TABLE ORA-39083: Object type TABLE:"MIS"."FACT_IRM_CIG" failed to create with error: ORA-14037: partition bound of partition "POLD" is too high Failing sql is: CREATE TABLE "MIS"."FACT_IRM_CIG" ("LOG_ID" CHAR(3 BYTE), "IRM_LOAD_ID" NUMBER NOT NULL ENABLE, "SRV_ID" VARCHAR2(255 BYTE), "START_DATE" CHAR(10 BYTE), "START_TIME" CHAR(12 BYTE), "END_DATE" CHAR(10 BYTE), "END_TIME" CHAR(12 BYTE), "RQST_DATA" VARCHAR2(4000 BYTE), "CRE_BY" VARCHAR2(30 BYTE), "CRE_DATE" DATE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 ORA-39083: Object type TABLE:"MIS"."FACT_IRM" failed to create with error: ORA-14037: partition bound of partition "POLD" is too high
Cause
NLS_DATE_FORMAT is causing the issue.
The table is partitioned with the following key
… PARTITION BY RANGE ("START_DATE") (PARTITION "POLD" VALUES LESS THAN (TO_DATE('2010-01-01','YYYY-MM-DD'))
NLS_DATABASE_PARAMETERS shows NLS_DATE_FORMAT is DD-MON-RR.
Solution
- Change the NLS_DATE_FORMAT to the format used for the partitioning .
- Run the impdp TTS again (after clean up of target).
- Revert back the NLS_DATE_FORMAT.