Solution : https://service.sap.com/sap/support/notes/830965 (SAP Service marketplace login required)
Summary :
SAP Note details an issue where tables like VBDATA and DDLOG grow excessively due to frequent INSERT and DELETE operations and usage of LONG RAW fields causing chained rows. This behavior is deemed design-intended rather than a defect. Recommended solutions involve: 1) Using the 'truncate table' command to reset the high watermark (HWM) and clean the free list, though it can risk data loss during runtime. 2) Reorganizing the table to compact data and reconstruct the free list efficiently without data loss. 3) Executing 'alter table deallocate unused', which partially frees up space. A definitive solution is to migrate VBDATA to an Automatic Segment Space Management (ASSM) tablespace designed in Oracle 9i, enhancing space management. Precautions include patching Oracle 9.2.0.5 to prevent data corruption before using ASSM.
Key words :
alter table vbdata deallocate unused, automatic segment space management, long raw fields, rapidly increasing size, high water mark, truncate table vbdata, 9i feature makes, table vbdata -, table increases, space administration
Related Notes :
| 896717 | Problems with tables in ASSM tablespaces |
| 817262 | Check tool for segment corruption in ASSM tablespace |
| 764015 | Segment corruption in ASSM tablespace |
| 620803 | Oracle 9i: Automatic Segment Space Management |