This content has been marked as final. Show 3 replies
Table Compression Enhancements in Oracle Database 11G Rel1 as as follows:
The compression clause can be specified at the tablespace, table or partition level with the following options:
•NOCOMPRESS - The table or partition is not compressed. This is the default action when no compression clause is specified.
•COMPRESS - This option is considered suitable for data warehouse systems. Compression is enabled on the table or partition during direct-path inserts only.
•COMPRESS FOR DIRECT_LOAD OPERATIONS - This option has the same affect as the simple COMPRESS keyword.
•COMPRESS FOR ALL OPERATIONS - This option is considered suitable for OLTP systems. As the name implies, this option enables compression for all operations, including regular DML statements. This option requires the COMPATIBLE initialization parameter to be set to 11.1.0 or higher.