ORA 02266 issues

Can someone let me know even if have disabled all the foreign key constraints that is referencing a table say tab_a, still getting the error message 02266 when trying to drop a table tab_a.

Disabled foreign keys from tables say tab_b, tab_c and tab_d. Found them using the following SQL script

select table_name, constraint_name
from dba_cons_columns
where column_name='col_nm1';

If i drop the table tab_a using cascade constraints it was successful but donot know what other constraint it is deleting other than the one that i was trying to disabling it and enabling it at the end.

Please help me out. thanks

-Saravanan.R- Received on Thu Jun 24 1999 - 15:36:46 CDT