ORA-31693 ORA-14501 When Loading Data Into A Non-Partitioned Table With DataPump Import(IMPDP) (Doc ID 1331413.1)

Last updated on FEBRUARY 20, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms

After exporting a partitioned table and trying to import the data into a non-partitioned table but with the same structure, fails with:

ORA-31693: Table data object "DEDB"."TT_CHRG_TRN":"TT_CHRG_TRN_2011P2" failed to load/unload and is being skipped due to error:
ORA-14501: object is not partitioned

The import log file shows:

Import: Release 10.2.0.4.0 - Production on Sunday, 22 May, 2011 10:08:59

Copyright (c) 2003, 2007, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "BACKAGENT_SVC"."SYS_IMPORT_FULL_02" successfully loaded/unloaded
Starting "BACKAGENT_SVC"."SYS_IMPORT_FULL_02": backagent_svc/********@xxxxxxxxxxxxxxx dumpfile=dan.1.%U.dmp directory=QML_REFRESH_DIR logfile=dan.1.impdp.log TABLE_EXISTS_ACTION=TRUNCATE PARALLEL=3 REMAP_TABLESPACE=TT_CHRG_TRN_DATA_2009P1:DEDB_DATA,
TT_CHRG_TRN_DATA_2009P2:DEDB_DATA,TT_CHRG_TRN_DATA_2010P1:DEDB_DATA,
TT_CHRG_TRN_DATA_2010P2:DEDB_DATA,TT_CHRG_TRN_DATA_2010P3:DEDB_DATA,
TT_CHRG_TRN_DATA_2010P4:DEDB_DATA,TT_CHRG_TRN_DATA_2010P5:DEDB_DATA,
TT_CHRG_TRN_DATA_2010P6:DEDB_DATA,TT_CHRG_TRN_DATA_2011P1:DEDB_DATA,
TT_CHRG_TRN_DATA_2011P2:DEDB_DATA,TT_CHRG_TRN_DATA_2011P3:DEDB_DATA,
TT_CHRG_TRN_DATA_MAX:DEDB_DATA
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39153: Table "DEDB"."TT_CHRG_TRN" exists and has been truncated. Data will be loaded but all dependent metadata will be skipped due to table_exists_action of truncate
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "DEDB"."TT_CHRG_TRN":"TT_CHRG_TRN_2010P1" 2.833 GB 21255502 rows
. . imported "DEDB"."TT_CHRG_TRN":"TT_CHRG_TRN_2009P2" 5.622 GB 42039421 rows
. . imported "DEDB"."TT_CHRG_TRN":"TT_CHRG_TRN_2011P1" 2.191 GB 17118827 rows
. . imported "DEDB"."TT_CHRG_TRN":"TT_CHRG_TRN_2010P4" 2.204 GB 16644136 rows
. . imported "DEDB"."TT_CHRG_TRN":"TT_CHRG_TRN_2010P5" 2.174 GB 16928009 rows
. . imported "DEDB"."TT_CHRG_TRN":"TT_CHRG_TRN_2010P3" 2.155 GB 16188003 rows
. . imported "DEDB"."TT_CHRG_TRN":"TT_CHRG_TRN_2010P6" 2.020 GB 15781061 rows
. . imported "DEDB"."TT_CHRG_TRN":"TT_CHRG_TRN_2010P2" 2.032 GB 15249170 rows
ORA-31693: Table data object "DEDB"."TT_CHRG_TRN":"TT_CHRG_TRN_2011P2" failed to load/unload and is being skipped due to error:
ORA-14501: object is not partitioned
. . imported "DEDB"."TT_CHRG_TRN":"TT_CHRG_TRN_2009P1" 18.85 MB 141670 rows
. . imported "DEDB"."TT_CHRG_TRN":"TT_CHRG_TRN_2011P3" 0 KB 0 rows
. . imported "DEDB"."TT_CHRG_TRN":"TT_CHRG_TRN_MAX" 0 KB 0 rows
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Job "BACKAGENT_SVC"."SYS_IMPORT_FULL_02" completed with 2 error(s) at 10:15:59

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