BUG: Wrong DDL for BLOB/CLOB

[orca777]

PLDEV 7.x
Hi devteam, i posted this - i think already in version 6 but still it's not fixed.

Output of dbms_Metadata

CREATE TABLE "ISIS"."DOCUMENTCONTENT"
   (	"ID" RAW(16) NOT NULL ENABLE,
	"STREAM" BLOB,
	"LASTUPDATE" DATE NOT NULL ENABLE,
	 CONSTRAINT "DOCUMENTCONTENT_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 5 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 5242880 NEXT 524288 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "ISISIXM"  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 5242880 NEXT 524288 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "ISISDAM"
 LOB ("STREAM") STORE AS "DOCUMENTCONTENT_LOB_SEG"(
  TABLESPACE "ISISDAM" DISABLE STORAGE IN ROW CHUNK 32768 PCTVERSION 10
  CACHE
  STORAGE(INITIAL 131072 NEXT 524288 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) ;

Ouput of PL/SQL-Developer

create table DOCUMENTCONTENT
(
  ID         RAW(16) not null,
  STREAM     BLOB,
  LASTUPDATE DATE not null
)
tablespace ISISDAM
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 5M
    next 512K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );

The pl/sql developer output is much better formatted but misses the lob clause. For me this would be the same if i create a table with column typed NUMBER(10,2) and pl/sql-developer generates a FLOAT instead.

When i create a Clob column there is no special sub dialog for the lob clause, i get only a code window where i can use the templated options.

So there is no GUI support.

In the Oracle magagzine you post that the you supports all datatypes, all are supported but the more complex one where the user needs GUI assistance support is missing.

I say it again. The highest priority for a database GUI driven tool is to support all oracle types and table types with effective GUI elements.

I do not like T.O.A.D for example but it supports alle object types and all new 10G stuff like the dbms scheduler.

Still i miss GUI support for old thinks like materilazed view logs/Materialzed Views.
Sure this is a lot of work but usefull to the user.

I do not want to switch back to SQL*PLUS/notepad and dbms_metadata.

Greetings
Karl

 

[Marco Kalter]

There is currently no explicit support for LOB storage. I have added this to the list of enhancement requests.

 

[orca777]

Thx,
hopefully my critic was understand as a creative one.
Greetings
Karl