直接用DROP TABLE XXXX PURGE;
会遇到 ORA-02449: unique/primary keys in table referenced by foreign keys 错误.
改成 DROP TABLE cascade constraints PURGE;
即可!
然后, 就可以把几百个TABLE统统干掉.
直接用DROP TABLE XXXX PURGE;
会遇到 ORA-02449: unique/primary keys in table referenced by foreign keys 错误.
改成 DROP TABLE cascade constraints PURGE;
即可!
然后, 就可以把几百个TABLE统统干掉.