1 create tablespace Bill. --创建永远久表空间
datafile '/u01/tablespace/bill.dbf' size 3M
uniform size 128K
segment space management auto;
[@more@]1 create temporary tablespace billtmp ----创建临时表空间
2 tempfile '/u01/tablespace/billtmp.dbf' size 10M
3 extent management local
4* uniform size 128k
SQL> /
Tablespace created.
SQL> create undo tablespace billundo -----创建UNDO表空间
2 datafile '/u01/tablespace/billundo.dbf' size 10M
3 extent management local
4 /
2 datafile '/u01/tablespace/billundo.dbf' size 10M
3 extent management local
4 /
Tablespace created.
2 alter tablespace bill ----增加表空间的数据文件
add datafile '/u01/tablespace/bill2.dbf'
size 1M;
alter database -----修改表空间的数据文件
datafile '/u01/tablespace/bill.dbf'
resize 3M;
alter database ----设置自动扩展表空间
datafile '/u01/tablespace/bill.dbf'
autoextend on next 1M maxsize 20M;
3 1* drop tablespace bill2 including contents and datafiles ----删除表空间,其中contents , datafiles 可选
SQL> /
SQL> /
Tablespace dropped.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/640706/viewspace-1047888/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/640706/viewspace-1047888/