In this Document
|
|
Purpose |
|
|
Scope |
|
|
Details |
| 1.) Overviews |
| 2.) Operations in Tables |
| 3.) Working with LOBs and using DBMS_LOB |
| 4.) Migration to LOBs/Securefiles |
| 5.) Performance Issues |
| 6.) Errors |
|
|
References |
Applies to:
Oracle Database - Enterprise Edition - Version 8.1.7.4 and laterPL/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 |