无法drop table报如下错误:
SQL> drop table a;
drop table a
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
记得曾经修改过dual表，添加了一行记录：
SQL> truncate table dual;
Table truncated.
SQL> insert into dual values(‘X’);
1 row created.
SQL> commit;
Commit complete.
虽然select dual表还是一行，但其实还是两行，truncate之后再insert一条记录之后就可以了。