Toad World® Forums

sql nav 7.3 / oracle 12 c / lob table space

This is the extract ddl from toad for the same table.

CREATE TABLE SSADMIN.AWD_VOL_GPS_ENROLLMENT
(
PART_ID NUMBER(22) NOT NULL,
AWD_LOG_ID NUMBER(22) NOT NULL,
GROUP_NUM VARCHAR2(15 BYTE) NOT NULL,
PLAN_NUM VARCHAR2(15 BYTE) NOT NULL,
ENROLLMENT_DETAILS CLOB NOT NULL,
CREATED_DATE DATE NOT NULL
)
LOB (ENROLLMENT_DETAILS) STORE AS SECUREFILE AWD_VOL_GPS_ENROLLMENT (
TABLESPACE DOCUMENT_STAGE_LOB
ENABLE STORAGE IN ROW
CHUNK 8192
COMPRESS HIGH
NOCACHE
LOGGING
STORAGE (
INITIAL 8M
NEXT 8M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
))
TABLESPACE SSMT_DAT_S
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 128K
NEXT 128K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
MONITORING;

CREATE TABLE SSADMIN.AWD_VOL_GPS_ENROLLMENT
(PART_ID NUMBER(22,0) NOT NULL,
AWD_LOG_ID NUMBER(22,0) NOT NULL,
GROUP_NUM VARCHAR2(15) NOT NULL,
PLAN_NUM VARCHAR2(15) NOT NULL,
ENROLLMENT_DETAILS CLOB NOT NULL,
CREATED_DATE DATE NOT NULL)
SEGMENT CREATION IMMEDIATE
TABLESPACE SSMT_DAT_S
LOB (“ENROLLMENT_DETAILS”) STORE AS SECUREFILE AWD_VOL_GPS_ENROLLMENT
(
TABLESPACE SSMT_DAT_S
NOCACHE LOGGING
CHUNK 8192
)
NOPARALLEL
LOGGING
MONITORING
/

The 2nd extract is from sql nav 7.3. For some reason sql nav did not extract the correct tablespace name for the lob. We store our lob datatypes on a specific tablespace and define that tablespace as a secure file. Toad 12 extracted the 12 c table correctly, sql nav did not.

DON’T LET THOSE TOAD GUYS GET AWAY WITH THIS!!