创建表空间,表空间增加和删除数据文件,表空间只读模式,表空间下线与上线

SQL> alter database datafile '/u01/app/oracle/oradata/orcl/ts1.02.dbf' autoextend on next 1m maxsize 100m;

Database altered.

SQL> alter database datafile '/u01/app/oracle/oradata/orcl/ts1.02.dbf' autoextend off;

Database altered.

SQL> alter tablespace ts1 read only;

Tablespace altered.

SQL> select tablespace_name,file_name,ceil(bytes/1024/1024) mb
   from dba_data_files order by 1; 

 

SQL> select tablespace_name,status from dba_tablespaces;

TABLESPACE_NAME         STATUS
------------------------------ ---------
SYSTEM          ONLINE
UNDOTBS1         ONLINE
SYSAUX          ONLINE
TEMP          ONLINE
USERS          ONLINE
EYGLE          ONLINE
TS1          READ ONLY

7 rows selected.

SQL> alter tablespace ts1 read write;

Tablespace altered.

SQL> alter tablespace ts1 offline;

Tablespa