本文介绍Oracle数据库中表空间的基本操作，包括设置为只读、离线及调整存储配置等内容。文章详细解释了不同类型的表空间及其操作限制，并提供了具体命令示例。
--------
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.增加数据文件
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.增加数据文件
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
