oracle学习笔记09_管理表空间和数据文件
--------
system tablespace
Undo tablespace
Temporary Tablespaces
--------Read-Only Tablespaces/Read-Write Tablespaces
alter tablespace TABLESPACE read only;
影响1.Causes a checkpoint
影响2.Data available only for read operations
影响3.Objects can be dropped from tablespace
--------Taking a tablespace offline/online
alter tablespace TABLESPACE offline;
alter tablespace TABLESPACE online;
--------不能离线的表空间
SYSTEM tablespace
Tablespaces with active undo segments
Default temporary tablespace
--------Changeing Storage Settings(Can not be done for locally managed tablespaces)
--------resize tablespace
1.autoextend
2.手工alter database resize
3.增加数据文件
