Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************Got the opportunity to pen a Book on Database Cloud Services.......More details to follow.***************

Title : Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2020


Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

My Cloud Certifications:

AWS Certified Solutions Architect Associate

Azure Certified Administrator

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

Search This Blog

Saturday, September 26, 2015

Create and manage LOB segments

Create and manage LOB segments

Initializing Persistent LOBs to NULL or Empty

You can set a persistent LOB — ­that is, a LOB column in a table, or a LOB attribute in an object type that you defined— to be NULL or empty:

If a LOB column is initialized with EMPTY_CLOB() or EMPTY_BLOB(), then no LOB value exists, not even NULL. The row holds a LOB locator only. No additional LOB storage is used.

LOB storage characteristics that can be specified for a LOB column or a LOB attribute include the following:
  • Note that you can specify either PCTVERSION or RETENTION for BASICFILE LOBs, but not both. For SECUREFILE LOBs, only the RETENTION parameter can be specified.


A chunk is one or more Oracle blocks

Setting a Persistent LOB to Empty

SHAIKDB>insert into dedup values (1,empty_blob());

1 row created.

SHAIKDB>create table lob1 (id number,desc1 blob)  lob(desc1) store as bfilelob (tablespace lobs chunk 4k pctversion 5 storage (maxextents 5));

Table created.



DBMS_LOB can read and modify BLOBs, CLOBs, and NCLOBs; it provides read-only operations for BFILEs. The bulk of the LOB operations are provided by this package.

a)Oracle® Database SecureFiles and Large Objects Developer's Guide
11g Release 2 (11.2)  Part Number E10645-01 → 11 LOB Storage

b)Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)
-- Part Number E10577-03 --> 79 DBMS_LOB

No comments: