My Oracle Support Banner

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

Last updated on JULY 26, 2019

Applies to:

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

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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

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
Goal
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.