想删除以前建立的statspack所使用的表空间perfstat,
执行drop tablespace perfstat including contents and datafiles cascade constraints时报错:
ORA-00604: error occurred at recursive SQL level 2
ORA-01422: exact fetch returns more than requested number of rows试着删除用户:drop user perfstat cascade ,也出错:
ORA-00604: error occurred at recursive SQL level 2
ORA-01422: exact fetch returns more than requested number of rows哪位对statspack有研究的,帮忙解决下,谢谢了。
执行drop tablespace perfstat including contents and datafiles cascade constraints时报错:
ORA-00604: error occurred at recursive SQL level 2
ORA-01422: exact fetch returns more than requested number of rows试着删除用户:drop user perfstat cascade ,也出错:
ORA-00604: error occurred at recursive SQL level 2
ORA-01422: exact fetch returns more than requested number of rows哪位对statspack有研究的,帮忙解决下,谢谢了。
如果是9i的会按照实际显示。
你的问题可以通过如下方法试试:
truncate table dual;
insert into dual values('X');
commit;