Hi,
We are using Oracle DB "12c Enterprise Edition Release 12.2.0.1.0".
A particular table occupies huge space in the PROD DB, hence was searching how to overcome this issue.
Deletion is NOT allowed even for older data. Even if you archive to some other tablespace, data is going to be inside the server only.
Hence was looking for compression logic. And have seen a feature "alter table <table_name> move compress for all operations;"
This was very much helpful. I've verified the space before & after compression occupied by this table. It got reduced from 25GB to 3GB.
However after this, I'm NOT able to see the records for a particular driving column, say column 'A' for a value when I issue 'select * from'. But strangely If I issue 'group by' clause, it shows the exact count against the same value.
Could you please help?
Regards,
Ram.