Solution : https://service.sap.com/sap/support/notes/500340 (SAP Service marketplace login required)
Summary :
The SAP Note addresses the implementation and management of LOB (Large Object) data types within SAP systems, specifically focusing on characteristics, storage, and management aspects associated with LOBs. LOBs are used to store large volumes of unstructured data and offer several advantages over older data types, such as larger size limits and support for partitioning. The note details the process of creating tables with LOB columns, managing LOB storage parameters, and considerations during table reorganization. It also covers the commands and SQL queries necessary for handling LOB data, including how to determine the associated table and column for a particular LOB object and the preparation needed for handling problems like ora-1658 errors. Additionally, the use and alteration of storage parameters for LOBSEGMENT and LOBINDEX are discussed, alongside the implications of using LOBs in different SAP and database environments.
Key words :
terms lob blob clob nclob bfile sys_lob, alter table <table> modify lob <lobsegment> cache/nocache, $$ sys_lob$$ rawstring stringlobsegment lobindex ora-1658 solution 1, exp/imp respectivly expdp/impdp, pctversion withalter table <table> modify lob, alter table <table> modify lob, commandalter table <table> modify lob, direct path export exp-00067 occurs, locally managed tablespaces changing defaults, current dataa large pctversion reduces
Related Notes :
| 1818320 | Oracle 11g Advanced Compression for LONG data restriction |
| 1436352 | Oracle Database 11g Advanced Compression for SAP Systems |
| 893441 | Adjustment of SDB2FORA for the caching of LOBs |
| 666061 | FAQ: Database objects, segments and extents |
| 659946 | FAQ: Temporary tablespaces |
| 656374 | EXP-00067: Table will be exported in conventional path. |
| 618868 | FAQ: Oracle performance |
| 533455 | Terminations due to higher number of extents |
| 3807 | Error messages regarding rollback and undo segments |
| 3155 | Termination due to tablespace overflow |