ORA-39325: TABLE_EXISTS_ACTION cannot be applied to “MYSCHEMA”.”MYTABLE”

I ran an export which included the table EMP. Later I imported this into a test instance using TABLE_EXISTS_ACTION=SKIP, and received error ORA-39325: TABLE_EXISTS_ACTION cannot be applied to “MYSCHEMA”.”EMP”.

Upon further investigation, there was already a view named MYSCHEMA.EMP in the target database. So the object already existed, but not as a table. So it threw error ORA-39325.

This entry was posted in Uncategorized. Bookmark the permalink.