Create Table using LOB column

1. A LOB data type can be stored in three ways: inline, out of line, and externally. Storing LOB inline means storing it within the same location as its table. Storing LOB out of line means storing it within a separate tablespace and storing its location within the table. LOB can be stored externally by using the BFILE data type.
2. More than one column can be defined as a LOB data type within a table.
3. Each LOB column can be of a different LOB data type.
4. Partitioning of table data with one or more LOB columns is possible.
5. The LOB data type supports random access of data.
6. SQL statements define the LOB columns within a table and the LOB attributes within a user-defined object type. When defining the LOBs within a table, you can explicitly specify the tablespace and storage characteristics for each LOB.

LOB storage clause

LOB (LOB item name) store as {TABLESPACE 
<tablespace_name>}
{ENABLE / DISABLE STORAGE IN ROW}
{CHUNK <chunk_size in bytes>}
{PCTVERSION <value>}
{CACHE / NOCACHE LOGGING/NOLOGGING}
{storage parameters}

TABLESPACE

CACHE/NOCACHE

LOGGING/NOLOGGING

CHUNK

PCTVERSION

Examples of LOB columns

CREATE OR REPLACE TYPE CUSTOMER_PHOTO_OBJ_TYPE AS OBJECT
(
CUSTOMER_ID  NUMBER (10),
CUSTOMER_PHOTO    BLOB,
CREATED_DATE      DATE
);

CREATE TABLE CUSTOMER_PHOTO_OBJ_TABLE OF 
CUSTOMER_PHOTO_OBJ_TYPE
(CONSTRAINT CUSTOMER_PHOTO_OBJ_PK
PRIMARY KEY (CUSTOMER_ID));

CREATE TABLE CUSTOMER_PHOTO_OBJ_TABLE
(
CUSTOMER_ID  NUMBER (10),
CUSTOMER_PHOTO    BLOB,
CREATED_DATE      DATE
)
LOB (CUSTOMER_PHOTO) STORE AS 
(CHUNK 4096 
PCTVERSION 5 
NOCACHE LOGGING 
STORAGE (MAXEXTENTS 5)
);

CREATE TABLE CUSTOMER_PHOTO_OBJ_TABLE
(
CUSTOMER_ID  NUMBER (10),
CUSTOMER_PHOTO    BFILE,
CREATED_DATE      DATE
)