Create a table that includes CLOB (LOB) storage . When you select the script tab, the DDL script for the CLOB information is not shown.
Example
IN ORIGINAL DDL:
CREATE TABLE TEST_CLOB_PART
(
TRANSACTION_TYPE VARCHAR2(30 BYTE) NOT NULL,
MESSAGE_ID VARCHAR2(64 BYTE) NOT NULL,
VERSION NUMBER NOT NULL,
SOURCE_SYSTEM_ID VARCHAR2(64 BYTE) NOT NULL,
XML CLOB NOT NULL,
UPDATE_DATETIME TIMESTAMP(6) NOT NULL
)
LOB(XML) STORE AS TEST_CLOB_PART_XML
(
TABLESPACE CSI_CLOB_D
DISABLE STORAGE IN ROW
CACHE
CHUNK 8192
)
TABLESPACE CSI_D
NOLOGGING
STORAGE(BUFFER_POOL KEEP)
PARALLEL 2
PARTITION BY LIST(TRANSACTION_TYPE)
( PARTITION SLATE VALUES ( 'SLATE') ,
PARTITION TRADE VALUES ( 'TRADE') ,
PARTITION BLOCK VALUES ( 'BLOCK')
);
In TOAD script tab, it shows:
Prompt drop TABLE TEST_CLOB_PART;
DROP TABLE TEST_CLOB_PART CASCADE CONSTRAINTS PURGE;
Prompt Table TEST_CLOB_PART;
CREATE TABLE TEST_CLOB_PART
(
TRANSACTION_TYPE VARCHAR2(30 BYTE) NOT NULL,
MESSAGE_ID VARCHAR2(64 BYTE) NOT NULL,
VERSION NUMBER NOT NULL,
SOURCE_SYSTEM_ID VARCHAR2(64 BYTE) NOT NULL,
XML CLOB NOT NULL,
UPDATE_DATETIME TIMESTAMP(6) NOT NULL
)
TABLESPACE CSI_D
NOLOGGING
PARTITION BY LIST (TRANSACTION_TYPE)
(
PARTITION SLATE VALUES ('SLATE')
NOLOGGING
NOCOMPRESS
TABLESPACE CSI_D,
PARTITION TRADE VALUES ('TRADE')
NOLOGGING
NOCOMPRESS
TABLESPACE CSI_D,
PARTITION BLOCK VALUES ('BLOCK')
NOLOGGING
NOCOMPRESS
TABLESPACE CSI_D
)
NOCOMPRESS;
Option to exlcude LOB storage is checked.
Select the View | Edit script options (icon) found inside the scripts Tab | Uncheck 'Exlcude LOB storage'.
Example of the data that should now appear in your Script Tab
LOGGING
LOB (CLOB_TEST) STORE AS
( TABLESPACE SYSTEM
ENABLE STORAGE IN ROW
CHUNK 8192
PCTVERSION 10
NOCACHE
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
)
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center