ORA-39152 Table Exists Data Will be Appended to Existing Table (Doc ID 818535.1)

Last updated on SEPTEMBER 30, 2009

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7
This problem can occur on any platform.

Symptoms

Exporting a series of tables using the QUERY parameter to filter data. 

How can one import the data from the export dump file to another database that has the same table names with the same structure?

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms