Friday, July 27, 2012

ORA-39152: Table exists

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.

To get around this you can use the following DataPump import parameters:
CONTENT=DATA_ONLY TABLE_EXISTS_ACTION=APPEND EXCLUDE=INDEX,CONSTRAINT


Thank you
Osama mustafa

No comments:

Post a Comment