在一个客户的数据库中,想删除一个表空间,但是被拒绝
现象如下:
drop tablespace gsdata_mid including contents
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-20052: ORA-20052: TableSpace Agent Error!
ORA-06512: at line 5
ORA-06512: at "ASSET.TOPSEXCEPTION", line 30
ORA-06512: at line 1
ORA-06512: at line 58
ORA-20052: TableSpace Agent Error!
原因:公司的安全产品具有恢复表空间的功能,但因为其中的某个license 没有被关闭,所以回报错.
解决办法:
update mc$asset_license set enabled='NO';
commit;
sqlplus "system/******@***"
drop tablespace gsdata_mid including contents;
删除表空间成功.
现象如下:
drop tablespace gsdata_mid including contents
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-20052: ORA-20052: TableSpace Agent Error!
ORA-06512: at line 5
ORA-06512: at "ASSET.TOPSEXCEPTION", line 30
ORA-06512: at line 1
ORA-06512: at line 58
ORA-20052: TableSpace Agent Error!
原因:公司的安全产品具有恢复表空间的功能,但因为其中的某个license 没有被关闭,所以回报错.
解决办法:
update mc$asset_license set enabled='NO';
commit;
sqlplus "system/******@***"
drop tablespace gsdata_mid including contents;
删除表空间成功.