What is large object in oracle? Explain its purposes

What is large object in oracle? Explain its purposes.

Large objects (LOB’s) are exclusively used to hold large amounts of data. It can hold data in tetra bytes. Different types of LOBs include internal, external, persistent and temporary. Binary LOB’s are typically used to store graphics, video, or audio data.


- Enables you to access and manipulate the data efficiently in your application.
- Is optimized for large amounts of data.
- Provides a uniform way of accessing data stored within the database or outside the database.
Types of large objects in oracle
BLOBs, CLOBs, and NCLOBs are Internal LOBs stored inside database tablespaces to optimize space and efficient access......
Define read-only replication and its uses
Read only replication creates local copy of table data originating from one or more remote master tables......
Read-only replication and snapshots
Replication is the process of copying database into one or more databases to make a system distributed......
Post your comment