Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to solve the problem of specifying the default table space of interval partition table clob. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

The following table creation statement specifies that the red part causes the clob field contained in the automatically generated partition to be placed in the default tablespace; otherwise, it will be placed in the user's default tablespace

CREATE TABLE TBL_SMS_LOG_NEW

(

N_SMS_LOGID NUMBER (20)

C_REQ_EMP VARCHAR2 (300 BYTE)

C_REQ_DPT VARCHAR2 (300 BYTE)

T_REQ_TM DATE

C_REQ_TYPE VARCHAR2 (20 BYTE)

C_REQ_CONTEXT CLOB

C_RES_CODE VARCHAR2 (50 BYTE)

C_RES_MSG VARCHAR2 (2000 BYTE)

C_RES_CONTEXT CLOB

C_SUCCESS_FLAG VARCHAR2 (10 BYTE)

C_CASE_NO VARCHAR2 (30 BYTE)

C_MOBILE_TEL VARCHAR2 (50 BYTE)

C_PLY_NO VARCHAR2 (30 BYTE)

C_SMS_INFOID VARCHAR2 (30 BYTE)

)

LOB (C_REQ_CONTEXT) STORE AS (TABLESPACE CLAIM_LOB)

LOB (C_RES_CONTEXT) STORE AS (TABLESPACE CLAIM_LOB)

TABLESPACE CLAIM

PCTFREE 0

INITRANS 1

MAXTRANS 255

PARTITION BY RANGE (T_REQ_TM)

INTERVAL (NUMTOYMINTERVAL (6)

(

PARTITION PART1406 VALUES LESS THAN (TO_DATE ('2014-07-01 00 SYYYY-MM-DD HH24:MI:SS',' NLS_CALENDAR=GREGORIAN'))

NoLOGGING

COMPRESS

TABLESPACE CLAIM

LOB (C_REQ_CONTEXT) STORE AS

(TABLESPACE CLAIM_LOB

ENABLE STORAGE IN ROW

CHUNK 8192

RETENTION

NOCACHE

STORAGE (

INITIAL 64K

NEXT 1M

MINEXTENTS 1

MAXEXTENTS UNLIMITED

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

BUFFER_POOL DEFAULT

)

)

LOB (C_RES_CONTEXT) STORE AS

(TABLESPACE CLAIM_LOB

ENABLE STORAGE IN ROW

CHUNK 8192

RETENTION

NOCACHE

STORAGE (

INITIAL 64K

NEXT 1M

MINEXTENTS 1

MAXEXTENTS UNLIMITED

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

BUFFER_POOL DEFAULT

)

)

PCTFREE 0

INITRANS 1

MAXTRANS 255

STORAGE (

INITIAL 64K

NEXT 1M

MINEXTENTS 1

MAXEXTENTS UNLIMITED

BUFFER_POOL DEFAULT

)

);

On how to solve the interval partition table clob default tablespace assignment problem is shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.