Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...


. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |


Oracle 11g New Features

Online Oracle Training

Oracle 11g: Table Compression

Now, on Oracle 11g you can Compress an oracle table.
Remember that any compression is CPU intensive. It is not a good idea to compress OLTP tables.

The following is an example of how to create a compressed table.

create table my_compressed_table (
  c1 varchar2(10),
  c2 varchar2(30),
compress for all operations;

The clause "compress for all operations" enables compression on all DML activities like INSERT, UPDATE, etc. Notice that the compress doesn't happen immediately. The compression algorithm will start in the block when it is needed to minimize the performance impact on the database.



Good Luck!


Web web site