SQL Developer Data Modeler

SQL Developer Data Modeler 24.3.1.351.0831

When adding a CLOB column with a Lob Storage, the DDL output by Tools > Compare/Merge Models is incorrect.

Testcase:

Save the following as “before.sql”:

CREATE TABLESPACE MY_TABLESPACE;
CREATE TABLE MY_TABLE 
   ( 
    my_column NUMBER
   ) 
;

Save the following as “after.sql”:

CREATE TABLESPACE MY_TABLESPACE;
CREATE TABLE MY_TABLE 
   ( 
    my_column NUMBER,
    my_clob_column CLOB 
   ) 
   LOB ( my_clob_column ) STORE AS 
       ( 
       TABLESPACE MY_TABLESPACE
       RETENTION 
       DISABLE STORAGE IN ROW 
       NOCACHE 
   ) 
;

File > Import > DDL File
after.sql
Oracle Database 12cR2
Merge
Should show a table with 2 columns.
Save as after.dmd
File > Close

File > Import > DDL File
before.sql
Oracle Database 12cR2
Should show a table with 1 column.
Save as before.dmd

Tools > Compare/Merge Models
Design To Compare: after.dmd
RDBMS Site: Oracle Database 12cR2
OK
DDL Preview

Shows:

ALTER TABLE MY_TABLE ADD 
   ( 
    my_clob_column CLOB 
   LOB ( my_clob_column ) STORE AS 
       ( 
       TABLESPACE MY_TABLESPACE 
       
       RETENTION 
       DISABLE STORAGE IN ROW 
       NOCACHE 
   ) 
   ) 
;

Running this DDL raises "ORA-00907: missing right parenthesis". It should be:

ALTER TABLE MY_TABLE ADD 
   ( 
    my_clob_column CLOB 
   ) 
   LOB ( my_clob_column ) STORE AS 
       ( 
       TABLESPACE MY_TABLESPACE 
       
       RETENTION 
       DISABLE STORAGE IN ROW 
       NOCACHE 
   ) 
;