tablespace offline online

非归档下可以离线表空间，不能离线数据文件
[code]SQL> create tablespace awen02 datafile '+DATA' size 100m;

Tablespace created.
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
+DATA/enmo10/datafile/system.261.803141869
+DATA/enmo10/datafile/undotbs1.262.803141877
+DATA/enmo10/datafile/sysaux.263.803141881
+DATA/enmo10/datafile/undotbs2.265.803141887
+DATA/enmo10/datafile/users.266.803141893
+DATA/enmo10/datafile/awen02.271.812361655

6 rows selected.
SQL> create table object_awen tablespace awen02 as select * from dba_objects;

Table created.

SQL> select count(*) from object_awen;

COUNT(*)
----------
44225

SQL> alter tablespace awen02 offline;

Tablespace altered.

SQL> select count(*) from object_awen;
select count(*) from object_awen
*
ERROR at line 1:
ORA-00376: file 6 cannot be read at this time
ORA-01110: data file 6: '+DATA/enmo10/datafile/awen02.271.812361655'


SQL> alter tablespace awen02 online;

Tablespace altered.

SQL> select count(*) from object_awen;

COUNT(*)
----------
44225

SQL>[/code]