我觉得你第一次地做法没有问题删除文件后,删除表空间:DROP TABLESPACE <tablespace_name> INCLUDING CONTENTS;
1。关闭数据库shutdown abort 2。STARTUP RESTRICT MOUNT 3. Offline drop 数据会滚段文件 ALTER DATABASE DATAFILE '<full_path_file_name>' OFFLINE DROP; 4。alter database open 5. 删除表空间:DROP TABLESPACE <tablespace_name> INCLUDING CONTENTS; 今天真怪
在alter database open是出ora-00600错误,后面一大排数字!
13 /oracle8/app/oracle/product/8.0.5/dbs/D:ORANTDATABASERBS1ORCL.ORA
14 /oracle8/app/oracle/product/8.0.5/dbs/D:ORANTDATABASEINDEX_1.ORA
2。STARTUP RESTRICT MOUNT
3. Offline drop 数据会滚段文件
ALTER DATABASE DATAFILE '<full_path_file_name>' OFFLINE DROP;
4。alter database open
5. 删除表空间:DROP TABLESPACE <tablespace_name> INCLUDING CONTENTS;
今天真怪