ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 表空间

oracle 表空间

原创 Linux操作系统 作者:gaiguoxiang 时间:2012-05-20 13:32:32 0 删除 编辑

create tablespace ggx datafile '/u01/oracle/oradata/orcldb1/ggx01.dbf' size 1M
autoextend on next 2M maxsize 9M;


TABLESPACE_NAME CURRENT_TOTAL(MB) USED(MB) FREE(MB) FREE% AUT MAX_TOTAL(MB)
------------------------------ ----------------- ---------- ---------- ---------- --- -------------
SYSTEM 480 475.88 4.125 .86 YES 32767.98
SYSAUX 270 247.13 22.875 8.47 YES 32767.98
GX 1 .13 .875 87.5 NO 1
GGX 1 .06 .9375 93.75 YES 9
UNDOTBS1 215 9.75 205.25 95.47 YES 32767.98
USERS 5 .06 4.9375 98.75 YES 32767.98

6 rows selected.

alter database datafile '/u01/oracle/oradata/orcldb1/ggx01.dbf' resize 3M;

TABLESPACE_NAME CURRENT_TOTAL(MB) USED(MB) FREE(MB) FREE% AUT MAX_TOTAL(MB)
------------------------------ ----------------- ---------- ---------- ---------- --- -------------
SYSTEM 480 475.88 4.125 .86 YES 32767.98
SYSAUX 270 247.13 22.875 8.47 YES 32767.98
GX 1 .13 .875 87.5 NO 1
UNDOTBS1 215 9.75 205.25 95.47 YES 32767.98
GGX 3 .06 2.9375 97.92 YES 9
USERS 5 .06 4.9375 98.75 YES 32767.98

6 rows selected.

alter tablespace ggx add datafile '/u01/oracle/oradata/orcldb1/ggx02.dbf' size 5M;

TABLESPACE_NAME CURRENT_TOTAL(MB) USED(MB) FREE(MB) FREE% AUT MAX_TOTAL(MB)
------------------------------ ----------------- ---------- ---------- ---------- --- -------------
SYSTEM 480 475.88 4.125 .86 YES 32767.98
SYSAUX 270 247.13 22.875 8.47 YES 32767.98
GX 1 .13 .875 87.5 NO 1
UNDOTBS1 215 9.75 205.25 95.47 YES 32767.98
GGX 8 .13 7.875 98.44 YES 14
USERS 5 .06 4.9375 98.75 YES 32767.98

6 rows selected.

alter database datafile '/u01/oracle/oradata/orcldb1/ggx01.dbf' resize 15M;

TABLESPACE_NAME CURRENT_TOTAL(MB) USED(MB) FREE(MB) FREE% AUT MAX_TOTAL(MB)
------------------------------ ----------------- ---------- ---------- ---------- --- -------------
SYSTEM 480 475.88 4.125 .86 YES 32767.98
SYSAUX 270 247.13 22.875 8.47 YES 32767.98
GX 1 .13 .875 87.5 NO 1
UNDOTBS1 215 9.75 205.25 95.47 YES 32767.98
USERS 5 .06 4.9375 98.75 YES 32767.98
GGX 20 .13 19.875 99.38 YES 14

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25517773/viewspace-730296/,如需转载,请注明出处,否则将追究法律责任。

上一篇: AWR导出
请登录后发表评论 登录
全部评论

注册时间:2011-06-22

  • 博文量
    41
  • 访问量
    105626