Master Note: Overview of Oracle Large Objects (BasicFiles LOBs and SecureFiles LOBs)
(Doc ID 1490228.1)
Last updated on AUGUST 11, 2020
Oracle Database - Enterprise Edition - Version 188.8.131.52 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A and later Oracle Cloud Infrastructure - Database Service - 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!