Solution : https://service.sap.com/sap/support/notes/1431296 (SAP Service marketplace login required)
Summary :
BRSPACE 7.20 introduces new functionalities for handling LOBs and table compression in Oracle 11g databases, enhancing data management efficiency. Featuring new LOB types - SecureFile LOBs, these provide significant performance improvement, data compression, and encryption options. Additionally, the release supports a new and improved method, COMPRESS FOR OLTP, for table compression aimed at substantial memory savings. Key additions include the "lob2lob" action facilitating the conversion of old LOBs to SecureFile LOBs, and enhanced compression options ("-c|-compress" and "-lc|-lobcompr") specifically designed for reorganization tasks in the BRSPACE tool. Syntax enhancements aim at easing usage and integration with the existing system configurations. This note outlines the technical details, recommended usage scenarios, and syntax of these new options, ensuring optimal utilization of space and resource management within the Oracle database system under SAP's framework.
Key words :
failure stop - stop reorganization suspend - suspend reorganization resume - resume reorganization long2lob - convert long fields, reorg - reorganize tables reopart - reorganize table partitions check - check tables, lobs dtab - decompress tables dlob - decompress lobs dtablob - decompress tables, action ctab - compress tables clob - compress lobs ctablob - compress tables, - performance improvements - data compression - data encryption, promises significant memory space savings, lobs ctab_only - compress uncompressed tables, lobs heap2iot - convert heap tables, clob_only -lc low -sctthis processes, intensive data exchange takes place
Related Notes :
| 1818320 | Oracle 11g Advanced Compression for LONG data restriction |
| 1464156 | Support for index compression in BRSPACE 7.20 |
| 1436352 | Oracle Database 11g Advanced Compression for SAP Systems |
| 1430669 | BR*Tools support for Oracle 11g |
| 1426979 | Oracle 11g: SecureFiles - The new way to store LOB data |
| 1289494 | FAQ: Oracle compression |