在删除数据的表空间的时候出现下面的错误,sys有drop tablespace的权限,这是为什么呢?
sys@TEST>DROP TABLESPACE temp01 including contents and datafiles;
DROP TABLESPACE temp01 including contents and datafiles
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01031: insufficient privileges
平台:WinXP
版本:10.2.0.1,使用了asm,但temp01不在asm上(删除asm上的表空间也有同样的问题)
sys@TEST>DROP TABLESPACE temp01 including contents and datafiles;
DROP TABLESPACE temp01 including contents and datafiles
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01031: insufficient privileges
平台:WinXP
版本:10.2.0.1,使用了asm,但temp01不在asm上(删除asm上的表空间也有同样的问题)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/498744/viewspace-281102/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/498744/viewspace-281102/