iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. 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!

 

Google
 
Web web site