Primary Note: Overview of Oracle Large Objects (BasicFiles LOBs and SecureFiles LOBs)
(Doc ID 1490228.1)
Last updated on JUNE 13, 2023
Oracle Database Cloud Service - Version N/A and later Oracle Database - Enterprise Edition - Version 22.214.171.124 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later Information in this document applies to any platform.
LOBs, or Large OBjects, are Oracle's preferred way of handling and storing non-character data, such as mp3s, videos, pictures, etc., and long character data. Binary large objects, or BLOBs, and character large objects, or CLOBs, can store up to terabytes of data The purpose of this document is to provide an overview of Oracle LOBs, and to attempt to explain what LOBs are, how and why to use them, and ways in which to manipulate LOB data.
This note is under development to improve the quality of the content.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!