ALTER SESSION SET DEFERRED_SEGMENT_CREATION = FALSE;

CREATE TABLE deferred_test (
   anumber      NUMBER,
   adate    DATE,
   aclob    CLOB,
   CONSTRAINT deferred_test_pk PRIMARY KEY (anumber)
) LOB(aclob) STORE AS SECUREFILE deferred_test_aclob tablespace USERS;

COLUMN SEGMENT_NAME FORMAT A30

SELECT segment_name, segment_type, bytes
  FROM user_segments;

ALTER SESSION SET DEFERRED_SEGMENT_CREATION = TRUE;

DROP TABLE deferred_test PURGE;

CREATE TABLE deferred_test (
   anumber     NUMBER,
   adate    DATE,
   aclob    CLOB,
   CONSTRAINT deferred_test_pk PRIMARY KEY (anumber)
) LOB(aclob) STORE AS SECUREFILE deferred_test_aclob tablespace USERS;

SELECT segment_name, segment_type, bytes
  FROM user_segments;

INSERT INTO deferred_test VALUES (1, sysdate, 'a clob');

COMMIT;

SELECT segment_name, segment_type, bytes
  FROM user_segments;

CREATE TABLE immediate_segment_test (
   anumber     NUMBER,
   adate    DATE,
   aclob    CLOB,
   CONSTRAINT immediate_segment_test_pk PRIMARY KEY (anumber)
) SEGMENT CREATION IMMEDIATE
  LOB(aclob) STORE AS SECUREFILE immediate_segment_test_aclob 
  TABLESPACE USERS;

CREATE TABLE deferred_segment_test (
   anumber    NUMBER,
   adate    DATE,
   aclob    CLOB,
   CONSTRAINT deferred_segment_test_pk PRIMARY KEY (anumber)
) SEGMENT CREATION DEFERRED
  LOB(aclob) STORE AS SECUREFILE deferred_segment_test_aclob 
  TABLESPACE USERS;

SELECT segment_name, segment_type, bytes
  FROM user_segments;

-- Clean Up 

DROP TABLE DEFERRED_SEGMENT_TEST PURGE;

DROP TABLE IMMEDIATE_SEGMENT_TEST PURGE;