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博客

tablespace offline ,但表可能DROP?

最新文章