oracle tablespace management

最新推荐文章于 2024-09-26 15:19:34 发布

dblucyne

最新推荐文章于 2024-09-26 15:19:34 发布

阅读量241

点赞数

分类专栏： Oracle基础知识文章标签： oracle tabs sql database 扩展

本文链接：https://blog.csdn.net/dblucyne/article/details/6930100

版权

Oracle基础知识专栏收录该内容

10 篇文章 0 订阅

订阅专栏

创建表空间

SQL> create tablespace tabs
  2  datafile '/u01/app/oracle/oradata/aircy/tabs01.dbf' size 2m
  3  autoextend on  next 1m maxsize unlimited
  4  segment space management auto 
  5  extent management local;

离线/在线/只读/可读可写

SQL> alter tablespace tabs offline;

Tablespace altered.

SQL> alter tablespace tabs online;

Tablespace altered.

SQL> alter tablespace tabs read only;

Tablespace altered.

SQL> alter tablespace tabs read write; 

Tablespace altered

扩展表空间

修改数据文件大小

SQL> alter database datafile '/u01/app/oracle/oradata/aircy/tabs01.dbf' resize 3m;

Tablespace altered.

增加数据文件

SQL> alter tablespace tabs add datafile '/u01/app/oracle/oradata/aircy/tabs02.dbf' size 1m
  2  autoextend on  next 1m maxsize unlimited;

Tablespace altered.

将表空间的数据文件设成自动扩展

SQL> alter database datafile  '/u01/app/oracle/oradata/aircy/tabs03.dbf'
  2  autoextend on next 4m maxsize unlimited;

Tablespace altered.

重新命名表空间名字

SQL> alter tablespace tabs rename to tab1;

Tablespace altered.

删除表空间

删除表空间

SQL> drop tablespace tab1 including contents;

Tablespace dropped.

删除表空间同时删除数据文件

SQL>  drop tablespace indextb including contents and datafiles;

Tablespace dropped.

删除数据文件

SQL> alter tablespace tabs drop datafile  '/u01/app/oracle/oradata/aircy/tabs02.dbf';

Tablespace altered.

SQL> alter database datafile  '/u01/app/oracle/oradata/aircy/tabs02.dbf' offline drop;

Database altered.