Primary Note: Overview of Oracle Large Objects (BasicFiles LOBs and SecureFiles LOBs)
(Doc ID 1490228.1)
Last updated on FEBRUARY 04, 2022
Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Backup Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Oracle Database Cloud Service - Version N/A and later Oracle Database - Enterprise Edition - Version 18.104.22.168 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!