DDL generation and LOB

[CTzen]

PL/SQL Developer 5.0x, 5.1

PL/SQL Developer doesn't recognize a separate tablespace for LOB segment, nor its options. Please see below. First DDL has been generated by OEM, second - PL/SQL Developer.

CREATE TABLE whol_content (
  content_id            NUMBER NOT NULL,
  name                  VARCHAR2(100),
  author                VARCHAR2(100),
  description           VARCHAR2(4000),
  file_url              VARCHAR2(200),
  content_body          CLOB,
  upload_date           DATE,
  last_modify_date      DATE,
  approve_date          DATE,
  expiration_date       DATE,
  last_modify_login_id  VARCHAR2(50),
  approve_login_id      VARCHAR2(50),
  archive_date          DATE,
  keywords              VARCHAR2(200),
  author_full_name      VARCHAR2(150),
  CONSTRAINT pk_whol_content PRIMARY KEY(content_id)
    USING INDEX TABLESPACE wsp_indx
)
TABLESPACE wsp_data
LOGGING LOB(content_body) STORE AS (
  TABLESPACE wsp_lob
  ENABLE STORAGE IN ROW
  NOCACHE CHUNK 8192 PCTVERSION 10
)

I removed STORAGE clause from both DDLs to save space.

-- create table
CREATE TABLE whol_content
(
  content_id           NUMBER NOT NULL,
  NAME                 VARCHAR2(100),
  author               VARCHAR2(100),
  DESCRIPTION          VARCHAR2(4000),
  file_url             VARCHAR2(200),
  content_body         CLOB,
  upload_date          DATE,
  last_modify_date     DATE,
  approve_date         DATE,
  expiration_date      DATE,
  last_modify_login_id VARCHAR2(50),
  approve_login_id     VARCHAR2(50),
  archive_date         DATE,
  keywords             VARCHAR2(200),
  author_full_name     VARCHAR2(150)
)
TABLESPACE wsp_data
;
-- create/recreate primary, unique and foreign key constraints
ALTER TABLE whol_content
  ADD CONSTRAINT pk_whol_content PRIMARY KEY (content_id)
  USING INDEX
  TABLESPACE wsp_indx
;

Thanks,
Slava

 

[Marco Kalter]

LOB storage parameters are indeed not supported, neither in the table definition editor, nor for the functions that generate the Table DDL. This is on the list of enhancement requests.

------------------
Marco Kalter
Allround Automations