Lalit Kumar BMessages: 2775Registered: May 2013 Location: World Wide on the Web

Senior Member

Jack14 wrote on Thu, 28 November 2013 07:03

Could you tell me which is the one that will delete the duplicate values and compress the data ?

1.Table compression.

2.Table defragmentation.

I don't know much about the defragmentation technique. However, advance table compression in 11g works well as publicized by Oracle. It is specially designed for the OLTP tables and works at block level. You can make use of the "Oracle Advanced Compression Advisor" package.