IMPDP with TABLE_EXISTS_ACTION - Why is Dependent Metadata Skipped (ORA-39153) ? (Doc ID 1567360.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Goal

What is the meaning of following error if an Import Data Pump job is started with TABLE_EXISTS_ACTION=SKIP or TABLE_EXISTS_ACTION=APPEND or TABLE_EXISTS_ACTION=TRUNCATE

...
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39153: Table "TC"."MY_TABLE" 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 SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "TC"."MY_TABLE"                             5.437 KB       3 rows
...

or in 11gR2 and higher:

...
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Table "TC"."MY_TABLE" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
...

or:

...
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Table "TC"."MY_TABLE" exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "TC"."MY_TABLE"                             5.437 KB       3 rows
...

or:

...
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Table "TC"."MY_TABLE" 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 SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "TC"."MY_TABLE"                             5.437 KB       3 rows
...

 

 

 

Solution

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