Unable to compress table
Hi
I have a table of 158G few days back before it went live, When I compressed it table size went down to 42G, since its live and cannot make changes without proper testing.
I created a table with CTAS
create table obia_dw.W_AP_XACT_FT1 compress parallel (degree 128) nologging as select * from OBIA_DW.W_AP_XACT_F;
it was only able to compress upto 14G now the new table size is 143G.
SUM(BYTES)/1024/1024/1024 SEGMENT_NAME
------------------------- -------------------- --------------------
143.769043 W_AP_XACT_FT1
157.813477 W_AP_XACT_F
Any direction please.