Database Administration (MOSC)

MOSC Banner

alter table shrink space does not work for me 10.2

edited Oct 21, 2015 10:03AM in Database Administration (MOSC) 12 commentsAnswered

This is my first post, apologize if this is the wrong place, and let me know where should I go for this.

This is Oracle 10.2 AIX.

I have a table CXADMIN.DAILY_INVENTORY has 1.5 million rows with 169 bytes each row.  The real data size is around 260 MB but the table itself is now 25 GB.  It has 52k extents. 

I tried to do an alter table cxadmin.daily_inventory shrink space cascade; and it did not change the size of the table.  When I export and import the table to the other database it only takes 260 MB.  I am sure if I do create table as select, then truncate the table then insert it back, it will shrink the space.  But what is bothering me is that "alter table shrink space " does not work on this one. 

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