demo10.sql

VC++是微软公司开发的一个IDE(集成开发环境),换句话说,就是使用c++的一个开发平台.有些软件就是这个编出来的

CREATE TABLE partitioned
( timestamp date,
  id        int
)
PARTITION BY RANGE (timestamp)
(
PARTITION part_1 VALUES LESS THAN
( to_date('01-jan-2000','dd-mon-yyyy') ) ,
PARTITION part_2 VALUES LESS THAN
( to_date('01-jan-2001','dd-mon-yyyy') )
)
/
create index partitioned_index
on partitioned(id)
GLOBAL
partition  by range(id)
(
partition part_1 values less than(1000),
partition part_2 values less than (MAXVALUE)
)
/
alter table partitioned add constraint
partitioned_pk
primary key(id)
/
drop index partitioned_index;
create index partitioned_index2
on partitioned(timestamp,id)
GLOBAL
partition  by range(id)
(
partition part_1 values less than(1000),
partition part_2 values less than (MAXVALUE)
)
/