DDL for LOBs

LOB definition can involve the CREATE TYPE and the CREATE TABLE statements. For example, the following statement specifies a CLOB within a datatype named lob_type:

CREATE OR REPLACE TYPE lob_type AS OBJECT ( 
         id  INTEGER, 
         data CLOB );

The following statement creates an object table (lob_table) in which each row is an instance of lob_type data:

CREATE TABLE lob_table OF lob_type;

The following statement stores LOBs in a regular table, as opposed to an object table as in the preceding statement:

CREATE TABLE lob_table1  (
                id  INTEGER,
                b_lob   BLOB,
                c_lob   CLOB,
                nc_lob  NCLOB,
                b_file  BFILE );

When creating LOBs in tables, you can set the LOB storage, buffering, and caching properties. See the Oracle8i SQL Reference manual and the Oracle8i Application Developer's Guide - Large Objects (LOBs) for information about using LOBs in the following DDL statements:

• CREATE TABLE and ALTER TABLE
  • LOB columns

  • LOB storage clause

  • NOCACHE and NOLOGGING options

• CREATE TYPE and ALTER TYPE
  • BLOB, CLOB and BFILE datatypes