oracle 表空间

最新推荐文章于 2023-09-07 11:06:38 发布

congnie1720

最新推荐文章于 2023-09-07 11:06:38 发布

阅读量74

点赞数

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25517773/viewspace-730296/