Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Shrink Table and Compression

614748Jun 9 2008 — edited Jun 9 2008
I have a table with compression turned on. The developers deleted 75% of the data in the table. So I would like bring the HWM to the correct level. I would like to use the shrink operation because it is very easy, online and doesn't invalidate indexes. However the shrink operation will not work against compressed tables. So I can Alter table nocompress and then issue the shrink command and it will work like a champ, and I can then turn on compression again. However the piece I am unsure of is after the shrink operation does the data that was still in the table become uncompressed?

I know that altering a table with compress or nocompress will not do anything to existing data but if the flag changes and then a shrink operation occurs will that affect the data in terms of compression?

Any insight is appreciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2008
Added on Jun 9 2008
5 comments
3,010 views