partition table- small practise

drop table test_pt
create table test_pt(id int,ct date)
partition by  range(ct)(
partition part_01 values less than(to_date('2009-01-01','YYYY-MM-DD','NLS_CALENDAR=GREGORIAN'))
    tablespace users
    pctfree 10
    pctused 40
    initrans 1
    maxtrans 255
    storage
    (
      initial 128K
      next 128K
      minextents 1
      maxextents unlimited
      pctincrease 0
    ),   

partition part_02 values less than(to_date('2009-02-01','YYYY-MM-DD','NLS_CALENDAR=GREGORIAN'))
    tablespace users
    pctfree 10
    pctused 40
    initrans 1
    maxtrans 255
    storage
    (
      initial 128K
      next 128K
      minextents 1
      maxextents unlimited
      pctincrease 0
    )
)

insert into test_pt(id,ct) values(1,to_date('2009-01-22','YY-MM-DD'))
select * from test_pt partition(part_02)
insert into test_pt(id,ct) values(2,to_date('2008-03-02','YY-MM-DD'))
select * from test_pt partition(part_01)
insert into test_pt(id,ct) values(3,to_date('2009-09-22','YY-MM-DD'))--ora-14400

alter table test_pt add primary key(id)
select * from test_pt
delete from test_pt where id =1

alter tablespace users offline

alter tablespace users online

update test_pt set ct= to_date('2009-01-01','YY-MM-DD') where id=1--ora-14402:
alter table test_pt enable row movement

commit

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20945761/viewspace-591546/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20945761/viewspace-591546/