Lob Column Definition are not correct rendered by Table Window

[orca777]

Hello Dev Taem;

i defined a table with a CLOB and the corresponding LOB-Clause to define lob-segment and lob-index explicit.

The input DDL was :

create table ISRE_TEMPLATES
(
  NAME         VARCHAR2(64) not null,
  CODE         CLOB,
  CODE_TYPE    VARCHAR2(32) not null,
  CODE_GROUP   VARCHAR2(32) not null,
  CODE_SUBTYPE VARCHAR2(32),
  SORT_GEN     INTEGER,
  CREATED      DATE not null,
  LAST_UPDATE  DATE
)
LOB (CODE)
    STORE AS ISRE_TEMPLATES_CODE_LSG (
        TABLESPACE ISISDAS
        DISABLE STORAGE IN ROW
        CACHE
        STORAGE (MINEXTENTS 2)
        INDEX ISRE_TEMPLATES_CODE_LIX (
            TABLESPACE ISISIXS
            STORAGE (MAXEXTENTS UNLIMITED)
        )
    )
tablespace ISISDAS
  pctfree 10
;

the Output DDL (View SQL) was :

create table ISRE_TEMPLATES
(
  NAME         VARCHAR2(64) not null,
  CODE         CLOB,
  CODE_TYPE    VARCHAR2(32) not null,
  CODE_GROUP   VARCHAR2(32) not null,
  CODE_SUBTYPE VARCHAR2(32),
  SORT_GEN     INTEGER,
  CREATED      DATE not null,
  LAST_UPDATE  DATE
)
tablespace ISISDAS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 64K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );

The lob clause is missing.
Could you fix it?

Regards
Carl

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[orca777]

Thanks a lot ;-)
Carl