Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 and later
PL/SQL - Version 8.1.7.4 and later
Information in this document applies to any platform.
***Checked for relevance on 16-Feb-2011***

Purpose

Provides an index to notes covering LOBs in Oracle databases, as well as the conventions introduced in 11g, BasicFiles for legacy LOB datatypes and SecureFiles.

Scope

This note gives an overview about all Articles related to the "LOB (Large OBjects) area" of the database as a reference for DBAs and Support staff.

Annotations: This note does not cover OCI and JDBC problems with LOB's, especially Import/Export Problems are not covered in this note..

Details

1.) Overviews

Note	Title/Subject
Note 61737.1	How to Manipulate Large Objects Using DBMS_LOB Package
Note 66046.1 Note 47740.1	Oracle8i: LOBs
Note 107441.1	Comparison between LOBs, and LONG & LONG Raw Datatypes
Note 74155.1	Oracle8i Temporary Large Objects
Note 114019.1	Oracle8 and Oracle8i Database Limits
Note 68899.1	[8.1.5] (18) LOBs (Lists LOB bugs in 8.1.5, mostly all fixed in current releases)
Note 468160.1	Introduction to SecureFiles
Note 1170351.1	Secure file Migration and Accessing securefile metadata information [Video]

2.) Operations in Tables

Note	Title/Subject

Note 159995.1	Different Behaviors of LOB and Lobindex Segments in 8.0, 8i and 9i
Note 130814.1	How to move LOB Data to Another Tablespace
Note 100548.1	Alter Table Modify LOB Storage Does Not Work
Note 118531.1	How to Compute the Size of a Table containing Outline CLOBs and BLOBs
Note 257772.1	CLOBs and NCLOBs character set storage in Oracle Release 8i, 9i and 10g.
Note 781635.1	How to modifiy a LOB to/from IN ROW storage
Note 453186.1	How to move LOB Data to Another Tablespace when the Table also contains a LONG column

3.) Working with LOBs and using DBMS_LOB

Note	Title/Subject
Note 148164.1	Search and Replace in LOB
Note 175648.1	Select Column of BLOB Returns SP2-678
Note 106314.1	Describe of Table in Server Manager shows LOB Datatype has Limit of 4000
Note 761388.1	How To Move Or Rebuild A Lob Partition
Note 471715.1	How to Load File Content to a BLOB Field and Unload BLOB Content to a File on the OS
Note 437432.1	How To Load CLOB Data from a File into a CLOB column using PL/SQL

4.) Migration to LOBs/Securefiles

Note	Title/Subject
Note 69627.1	How to Convert LONG Data into LOB Data using PL/SQL
Note 1071540.6	Can a LONG RAW be Converted to CLOB Datatype in Oracle 8.1?
Note 728758.1	HOW TO CONVERT TO/FROM SECUREFILES FROM/TO BASICFILES

5.) Performance Issues

Note	Title/Subject
Note 66431.1	LOBS - Storage, Redo and Performance Issues
Note 162345.1	LOBS - Storage, Read-consistency and Rollback
Note 268476.1	LOB Performance Guideline - White Paper
Note 740075.1	'enq HW - contention' For Busy LOB Segment
Note 457272.1	Update/Insert On BLOB Hangs With Wait Event “Control File Sequential Read”
Note 365156.1	Rebuilding LOB freepools

6.) Errors

ORA-xxxxx	Note	Title/Subject
ORA-00054	Note 196854.1	ORA-00054 During Alter Table Modify LOB
ORA-00932	Note 1078110.6	ORA-932 WHILE DOING A SELECT ON A TABLE FROM SQLPLUS WITH LIKE FUNCTION ON LOB
ORA-01632	Note 1025288.6	How to Diagnose and Resolve UNABLE TO EXTEND Errors
	Note 1014514.102	ORA-01632: MAX # EXTENTS (999) REACHED IN INDEX X.SYS_IL$ WHEN LOADING LOBS
ORA-01691	Note 1025288.6	How to Diagnose and Resolve UNABLE TO EXTEND Errors
	Note 48851.1	OERR: ORA 1691 unable to extend lob segment %s.%s by %s in tablespace%s
	Note 66431.1	LOBS - Storage, Redo and Performance Issues
	Note 1014629.102	ORA-01691: UNABLE TO EXTEND LOB SEGMENT TESTARCH.SYS_LOB#$
	Note 185131.1	Inserting Data into LOB Type Column Produces ORA-01691
	Note 108523.1	ORA-01691 unable to extend lob segment SCOTT.GLOB_STORE by 50 in table space
ORA-01555	Note 66431.1	LOBS - Storage, Redo and Performance Issues
ORA-01693	Note 1025288.6	How to Diagnose and Resolve UNABLE TO EXTEND Errors
	Note 1014040.102	ORA-01693: Max # Extents (999) Reached in LOB Segment X
ORA-03001	Note 159078.1	Cannot Create Table with LOB Column in Locally Managed Tablespace
ORA-03237	Note 116310.1	ORA-3237 Creating Certain Objects In Locally Managed Tablespace
ORA-06502	Note 1012132.102	ORA-6502 ORA-6512 CALLING PROCEDURES INSIDE DBMS_LOB PACKAGE
ORA-22275	Note 161530.1	ORA-22275 Calling a Clob Locator
	Note 790384.1	ORA-22275 When Selecting EMPTY_CLOB() From Dual.
ORA-22292	Note 99810.1	ORA-22292 CANNOT OPEN A LOB IN READ-WRITE MODE USING DBMS_LOB.OPEN
ORA-22853	Note 100192.1	ORA-22853 When Trying to Modify a LOB
	Note 423543.1	ORA-22853 Trying to ALTER TABLE MODIFY LOB
ORA-22858	Note 1056553.6	ORA-22858: CONVERTING LONG TO CLOB
ORA-22992	Note 158924.1	Referencing DBMS_LOB.COPY() Against Remote Table Fails With ORA-22992
	Note 119897.1	ORA-22992 When Trying To Select Lob Columns Over A Database Link
ORA-25008	Note 1065861.6	ORA-25008 WHEN UPDATING (C)LOB FIELD IN VIEW

Summary Note Index for BasicFiles and SecureFiles