IMPDP with TABLE_EXISTS_ACTION - Why is Dependent Metadata Skipped (ORA-39153) ?
(Doc ID 1567360.1)
Last updated on MAY 31, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterInformation 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
...
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
...
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 |