●NOCOMPRESS - 表或分区不压缩,当没有具体指定压缩子句时这是默认行为
●COMPRESS - 这个选项被认为适合于数据仓库系统,只在直接路径插入过程中在表或分区上启用压缩
●COMPRESS for direct_load operations - 这个选项与COMPRESS关键字有同样的效果(缺省值)
●COMPRESS for all operations --11gR1|11gR2 OLTP表压缩
●COMPRESS for oltp --11gR2 OLTP表压缩
●COMPRESS for query [LOW|HIGH] --11gR2 hybrid columnar compression(only available on Exadata servers)
●COMPRESS for archive [LOW|HIGH] --11gR2 hybrid columnar compression(only available on Exadata servers)
阅读(1001) | 评论(0) | 转发(0) |