Custom Tablespace¶
Input - custom tablespace
CREATE
TABLE
SEAS_VERSION_DDL_REL_ORA (
VERSION_ORA_ID VARCHAR2 (20)
,TAB_OBJ_ID VARCHAR2 (20)
,AUDIT_ID VARCHAR2 (20)
,DDL_SYS CLOB
,DDL_USER CLOB
,IF_CONFORM VARCHAR2 (3)
,DDL_TYPE_SYS VARCHAR2 (5)
,DDL_REN_REASON_SYS VARCHAR2 (4000)
,DDL_ERR_SYS VARCHAR2 (4000)
) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE (
INITIAL 655360 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
) TABLESPACE DRMS LOB (DDL_SYS) STORE AS BASICFILE (
TABLESPACE DRMS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE (
INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
)
) LOB (DDL_USER) STORE AS BASICFILE (
TABLESPACE DRMS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE (
INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
)
)
Output
CREATE
TABLE
SEAS_VERSION_DDL_REL_ORA (
VERSION_ORA_ID VARCHAR2 (20)
,TAB_OBJ_ID VARCHAR2 (20)
,AUDIT_ID VARCHAR2 (20)
,DDL_SYS CLOB
,DDL_USER CLOB
,IF_CONFORM VARCHAR2 (3)
,DDL_TYPE_SYS VARCHAR2 (5)
,DDL_REN_REASON_SYS VARCHAR2 (4000)
,DDL_ERR_SYS VARCHAR2 (4000)
) /*SEGMENT CREATION IMMEDIATE*/
/*PCTFREE 10*/
/*PCTUSED 40*/
/*INITRANS 1*/
/*MAXTRANS 255*/
/*NOCOMPRESS*/
/*LOGGING*/
/*STORAGE(INITIAL 655360 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)*/
/*TABLESPACE DRMS */
/*LOB (DDL_SYS) STORE AS BASICFILE ( TABLESPACE DRMS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))*/
/*LOB (DDL_USER) STORE AS BASICFILE ( TABLESPACE DRMS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))*/
;