While Oracle Database 10g offered limited table compression, Oracle Database 11g offers full blown table compression. Compression is supported in the following cases:
· Direct path SQL*Loader operations
· Create table as select commands
· Parallel inserts, or serial inserts with an append hint.
· Single row, or array insert and updates.This allows you to use compression on any database table, any time. The result can be a much reduced storage requirement and potentially much better performance!
More on this and many other new features in my upcoming book Oracle Database 11g New Features.