Oracle/DB
[Database] Table Shrink
swanseo
2016. 8. 9. 13:53
728x90
ALTER TABLE CTXSYS.DR$WAITING ENABLE ROW MOVEMENT;
ALTER TABLE CTXSYS.DR$WAITING SHRINK SPACE COMPACT CASCADE;
ALTER TABLE CTXSYS.DR$WAITING SHRINK SPACE CASCADE;
ALTER TABLE CTXSYS.DR$WAITING DISABLE ROW MOVEMENT;