Hi,
I run:
ALTER TABLE TOM.TAB1 SHRINK SPACE COMPACT;
ALTER TABLE TOM.TAB1 SHRINK SPACE CASCADE;
The "ALTER TABLE TOM.TAB1 SHRINK SPACE COMPACT" was completed in 2 hours, but "ALTER TABLE TOM.TAB1 SHRINK SPACE CASCADE" is still running after 8 hours, below the size of the table TAB1 and indexes:
SEGMENT_NAME...............GB
TAB1.................................166
IDX01................................83
SYS_C00.........................42
IDX02.............................142
IDX03..............................66
IDX04.............................122
Why "SHRINK SPACE COMPACT" takes long time?
Is there any way to check how much time does it take?
Thanks in advance!