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;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center