Question: I am importing a table and I get this
ORA-39152 error:
ORA-39152: Table exists. Data will be appended to existing
table but all dependent metadata will be skipped due to
table_exists_action of append.
How do I fix this ORA-39152 error?
Answer: The oerr utility shows
this for the ORA-39152 error:
ORA-39152: Table exists. Data will be
appended to existing table but all dependent metadata will
be skipped due to table_exists_action of append.
Cause : Using APPEND to import the existing tables, as to
not overrite them gives the following error:
Solution
: Truncating the table preserves the structure of the table
for future use, so you are seeing this error message because
there is a constraint or index in place.
See the following MOSC notes:
ORA-39152 Table Exists Data Will be
Appended to Existing Table [MOSC Note 818535.1]
Import DataPump: Import of Object Types Fails With ORA-39083
ORA-02304 or ORA-39117 ORA-39779 [MOSC
Note
351519.1]
How to Transfer the Data Between Tables
With Different Structures? [MOSC
Note
1078211.1]
Author Osama Mustafa notes that you can use the following
DataPump import parameters:
CONTENT=DATA_ONLY
TABLE_EXISTS_ACTION=APPEND EXCLUDE=INDEX,CONSTRAINT
