表空间管理

 

 

SQL> create tablespace tbs1 datafile '/opt/...tbs1.dbf' size 20M 
extent management local uniform size 512k;

SQL> create tablespace tbs2 datafile '/opt/...tbs2.dbf' size 20M
extent management local autoALLOCATE
segment space management manual;

SQL> create tablespace tbs3 datafile '/opt/...tbs3.dbf' size 20M
extent management local uniform size 512k
segment space management manual;

SQL> create tablespace tbs4 datafile '/opt/...tbs4.dbf' size 20M
autoextend on next 5M maxsize 100M;  --表空间数据文件自动扩展,每次5M,最大100M

SQL> create bigfile tablespace bigtbs datafile '/opt/...bigtbs.dbf' size 20M
autoallocate segment space management auto;

---
改变数据库默认创建的表空间文件类型
SQL> alter database set default bigfile tablespace;
SQL> alter database set default smallfile tablespace;



---
创建非标准表空间,不能创建非标准临时表空间
SQL> alter system set db_16k_cache_size=16384;
SQL> create tablespace tbs16 datafile '/opt/...tbs16.dbf' size 50M 
extent management local uniform size 128k blocksize 16k;

归档模式下备份ORCL数据库的USERS表空间

 

 

 

 

 

 

 

 

SQL> create temporary tablespace temp4 tempfile '/opt/...temp.dbf' size 20M
extent management local uniform size 2M tablespace group temp_group1;

SQL>alter tablespace temp2 tablespace group temp_group1;
SQL>alter tablespace temp2 tablespace group '';

SQL>alter database default temporary tablespace temp_group1;
SQL>create bigfile temporary tablespace temp3 tempfile '/opt/..temp3.dbf' size 100M;