Shrinking table
Hi,
I just finished to shrinked 1.6 TB table but the table size was not reduced. Any missing step here
10:28:36 >prompt table ecap2.JBPM_BYTEBLOCK
table ecap2.JBPM_BYTEBLOCK
10:28:36 >alter table "ECAP2"."JBPM_BYTEBLOCK" enable row movement;
Table altered.
10:28:36 >alter table "ECAP2"."JBPM_BYTEBLOCK" shrink space;
Table altered.
14:36:13 >select to_char(sysdate,'YYMMHH HH24:MI:SS') DateTime, current_timestamp from sys.dual;
DATETIME
---------------
CURRENT_TIMESTAMP
---------------------------------------------------------------------------
190902 14:36:13
23-SEP-19 02.36.13.167814 PM +08:00
Fragmented table
=============
>@fragment_tbl2.sql
OWNER TABLE_NAME size (MB) actual_data (MB) wasted_space (MB)
-------------------- ---------------------------------------- ---------- ---------------- -----------------
ECAP2 JBPM_BYTEBLOCK 1525308.52 1106624.38 418684.1
ECAP2 T_SPACE2ECAP_BACKUP 571.921875 449.53 122.4
ETDATA T_RELATED_SAMPLE 931.539063 615.58 316