How to fix the Oracle error ORA-39148: unable to import data into pre-existing queue table string. Table_exists_action of string being ignored for this table?

In this post, you’ll learn more about the Oracle ErrorORA-39148: unable to import data into pre-existing queue table string. Table_exists_action of string being ignored for this table with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-39148: unable to import data into pre-existing queue table string. Table_exists_action of string being ignored for this table

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.

How to fix the Error ORA-39148: unable to import data into pre-existing queue table string. Table_exists_action of string being ignored for this table ?

You can fix this error in Oracle by following the below steps

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.