(TIME_COL)
(
partition
PDEFAULT
valueslessthan
(
MAXVALUE
)
tablespace
TS_TEST
pctfree
10
initrans
1
maxtrans
255
storage
(
initial
64
K
next
1
M
minextents
1
maxextentsunlimited
)
);
-- Create/Recreate primary, unique and foreign key constraints
altertable
TEST_DAY_INTERVAL_PARTITION
addconstraint
PK_TEST_DAY_INTERVAL_PART
primarykey
(
ID
, TIME_COL)
usingindex
local
;
--
创建本地分区索引
2
创建分区表存储过程
CREATEORREPLACEPROCEDURE
p_test_create_partition
/* ver1.0 */
(p_errno
OUTNUMBER
,
--
返回错误编号,
0=
成功,
-1=
失败