压缩表空间的优点:节省时间,缺点:消耗CPU。一般用于存放历史数据,或者不经常update delete的表。
1.创建压缩表空间:
SYS@orcl> create tablespace compress_01 datafile '/u01/app/oracle/oradata/orcl/compress_01.dbf' size 10m default compress for oltp;
Tablespace created.
--查询表空间信息
SYS@orcl> selecttablespace_name,compress_for from dba_tablespaces;
TABLESPACE_NAME COMPRESS_FOR
------------------------------ ------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
EXAMPLE
TEST
COMPRESS_01 OLTP
2.创建一个普通表空间,修改普通表空间为压缩表空间
SYS@orcl> create tablespace tbs1datafile '/u01/app/oracle/oradata/orcl/tbs1.dbf' size 10m;
Tablesp