请教大家一个问题P201505的分区,在创建分区的时候没指定存放LOB字段表空间,这样可以指定存放lob大字段的表空间啊,下面是我建表和分区的语句;
create table PICTURE_INFO
(
RECORD_NO VARCHAR2(50),
IMAGE_NO NUMBER,
IMAGE BLOB,
IMAGE_TYPE VARCHAR2(10),
KEY_IMAGE NUMBER(1),
XML_IMAGEINFO XMLTYPE,
XML_DICOMINFO XMLTYPE,
XML_INFO XMLTYPE,
PRINT_ORDER NUMBER,
BODY_INFO VARCHAR2(500),
DESC_INFO VARCHAR2(500),
ORIENTATION_INFO VARCHAR2(500),
CANCEL_FLAG NUMBER(1),
CANCEL_DOCDBNAME VARCHAR2(20),
CANCEL_DOCNAME VARCHAR2(20),
CANCEL_DATE DATE,
ZOOMMULTIPLE VARCHAR2(12),
STANDBY01 VARCHAR2(50),
STANDBY02 VARCHAR2(50),
STANDBY03 VARCHAR2(50),
STANDBY04 VARCHAR2(50),
STANDBY05 VARCHAR2(50),
STANDBY06 VARCHAR2(50),
STANDBY07 VARCHAR2(50),
STANDBY08 VARCHAR2(50),
STANDBY09 VARCHAR2(50),
STANDBY10 DATE,
PARTITION_DATE DATE default SYSDATE,
MOVE_FLAG NUMBER(1)
)
partition by range (PARTITION_DATE)
(
partition P201505 values less than (TO_DATE(' 2005-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace PACS3I_INFO_P200505
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 80K
minextents 1
maxextents unlimited
),
这是我平时添加分区的语句
alter table pacs3i.picture_info add partition p201505 values less than (to_date('2015-06-01','yyyy-mm-dd'))
tablespace PACS3I_INFO_P201507 LOB (IMAGE) STORE AS (tablespace PACS3I_TMP_P201505 STORAGE (INITIAL 100M));
现在P201505这个分区已经建好了,
但LOB (IMAGE) STORE AS (tablespace PACS3I_TMP_P201505 STORAGE (INITIAL 100M));
没指定到存放LOB的表空间,
可以修改吗?