TABLE存放在TABLESPACE,USER有默认的,create partition table时可以指定TABLESPACE,例如:
CREATE TABLESPACE TS_201411 DATAFILE '/data1/ts_201411_1.dbf' SIZE 512M AUTOEXTEND ON NEXT 256M MAXSIZE UNLIMITED;
CREATE TABLE PT_201411
(
COMPANY_ID NUMBER(10) NOT NULL,
URL VARCHAR2(300 BYTE),
)
TABLESPACE TS_201411
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
LOGGING
PARTITION BY LIST (COMPANY_ID)
(
PARTITION PT_1000 VALUES (1000)
LOGGING
NOCOMPRESS
TABLESPACE TS_201411
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
)
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
取消
评论