Tuesday, 25 December 2012

alter index command for partition table


alter table <schema_name>.<table_name>
  add constraint <contraint_name> primary key (<column_name>, <column_name>)
  using index
  tablespace <tablespce_name>
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 1M
    next 1M
    minextents 1
    maxextents unlimited
    pctincrease 0
  )LOCAL;

No comments:

Post a Comment