某个表的主键索引建立在这个表空间了(表本身在另一个表空间)
手工删除掉它后, 再执行.查找这个索引:
SELECT t.owner, t.table_name, i.index_name
FROM dba_tables t, dba_indexes i
WHERE t.owner = i.owner
AND t.table_name = i.table_name
AND i.tablespace_name = 'THIS TABLESPACE'
AND t.tablespace_name <> 'THIS TABLESPACE';===========================
oldwain
---------------------------
http://www.itpub.net/index.php?referrerid=32
http://www.linuxforum.net/
http://expert.csdn.net/
http://www.oraclefan.net/
手工删除掉它后, 再执行.查找这个索引:
SELECT t.owner, t.table_name, i.index_name
FROM dba_tables t, dba_indexes i
WHERE t.owner = i.owner
AND t.table_name = i.table_name
AND i.tablespace_name = 'THIS TABLESPACE'
AND t.tablespace_name <> 'THIS TABLESPACE';===========================
oldwain
---------------------------
http://www.itpub.net/index.php?referrerid=32
http://www.linuxforum.net/
http://expert.csdn.net/
http://www.oraclefan.net/
svrmgrl>drop tablespace tablespace_name including contents cascade constraints;
我用pl/sql环境进行查询,没有查询结果,,
如何出现svrmgrl>提示符
递归sql层1出现错误
ora-02429:无法删除用于强制唯一/主键的索引。
的错误提示