tablespace offline ,但表可能DROP?

19:42:48 SQL> conn /as sysdba;
Connected.
19:54:11 SQL> alter tablespace test offline;

Tablespace altered.

Elapsed: 00:00:00.39
19:54:20 SQL> conn test/test;
Connected.
19:54:24 SQL> select * from  tt1 ;
select * from  tt1
               *
ERROR at line 1:
ORA-00376: file 11 cannot be read at this time
ORA-01110: data file 11: '/data/oradata/test01.dbf'

Elapsed: 00:00:00.01
19:54:34 SQL> drop table tt1;

Table dropped.

Elapsed: 00:00:01.05
19:55:00 SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27036311/viewspace-741185/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27036311/viewspace-741185/