1 查詢分區
select * from test.RECORDS2009 partition(P20090901)

2，分割分區
ALTER TABLE PMMSTKNWIP SPLIT PARTITION P2011
AT('20120101')
INTO (PARTITION P2011,PARTITION P2012);

ALTER TABLE PMMSTKNWIP SPLIT PARTITION P2012
AT('20130101')
INTO (PARTITION P2012,PARTITION P2013);

ALTER TABLE PMMSTKNWIP drop  PARTITION P2010;
ALTER TABLE PMMSTKNWIP drop  PARTITION P2011;

PMMLOTINFO ，
ALTER TABLE PMMLOTINFO SPLIT PARTITION P2011
AT('20120101')
INTO (PARTITION P2011,PARTITION P2012);

ALTER TABLE PMMLOTINFO SPLIT PARTITION P2012
AT('20130101')
INTO (PARTITION P2012,PARTITION P2013);
3,刪除分區
ALTER TABLE PMMTRSDTL drop  PARTITION P2010;
ALTER TABLE PMMTRSDTL drop  PARTITION P2011;
4，重建索引(先把索引拷貝出來，在刪除索引，然後重建)
   先刪除分區
    a,drop index test.IND_RECORD_INTIME
      drop index test.RECORDS_XX_IDX

    b,是主鍵：
      ALTER TABLE SFCDATA.BARCODE13
      MODIFY PRIMARY KEY DISABLE;
    c, alter table test.RECORDS
      drop  constraint RECORDS_XX_PK
   分割後需要重建table的所有索引。

alter table test.RECORDS
  add constraint RECORDS_XX_PK primary key (IDX)
  using index
  tablespace NDX_test
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 4M
    next 2M
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
-- Create/Recreate indexes
create index test.IND_RECORD_INTIME on test.RECORDS (INTIME);
create index test.RECORDS_XX_IDX on test.RECORDS (SNO)
  tablespace NDX_test
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 4M
    next 2M
    minextents 1
    maxextents unlimited
    pctincrease 0
  );