Page 1 of 1

Reorg compressed tablespace

PostPosted: Wed Apr 15, 2015 2:44 pm
by haldur
I have a big compressed tablespace which I want to reorg with discard. Is it possible to do this without data beeing uncompressed?
Regards,
Haldur

Re: Reorg compressed tablespace

PostPosted: Tue Jun 16, 2015 11:19 pm
by alexm
Hi haldur,

the documentation for the REORG utility answers your question: using REORG with DISCARD being specified decompresses the data (assuming you want your discarded records written to a file?).

Happy reading!
alexm