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