Thursday, 21 June 2012

ORA-39148: unable to import data into pre-existing queue table string. Table_exists_ action of string being ignored for this table

ORA-39148: unable to import data into pre-existing queue table string. Table_exists_ action of string being ignored for this table

Cause: A Data Pump import detected that a queue table that was to be imported already exists. Importing data into pre-existing queue tables is not supported.

Action: If the data from the dump file is desired, then drop the queue table and perform the import again, or use the import parameter table_exists_ action=replace.

No comments:

Post a Comment