oracle error ORA-02449: unique/primary keys in table referenced by foreign keys

[somashekar]

Is there any solution this oracle error without droping child table how we can drop parent table


please tell any solution for this error : ORA-02449: unique/primary keys in table referenced by foreign keys

[Rabbit]

You have to drop the foreign keys first.

[rski]

drop table parent cascade constraints;

It will drop parent table and all foreign keys, which point to it.