ORA-20039: cannot drop tables involved in foreign key relationships (Doc ID 1189699.1)

Last updated on SEPTEMBER 07, 2010

In this Document
  Symptoms
  Cause
  Solution
  References


Symptoms

Dropping a materialized view fails with errors:

SQL> drop materialized view oia_app.external_asset;
drop materialized view oia_app.external_asset
*
ERROR at line 1:
ORA-20039: cannot drop tables involved in foreign key relationships
ORA-06512: at "WMSYS.WM_ERROR", line 342
ORA-06512: at "WMSYS.WM_ERROR", line 351
ORA-06512: at "WMSYS.NO_VM_DROP_PROC", line 116
ORA-06512: at line 31

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