Database DataWarehousing (MOSC)

MOSC Banner

Unable to compress table

edited Feb 19, 2020 4:09AM in Database DataWarehousing (MOSC) 14 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center