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
    initial 1M
    next 1M
    minextents 1
    maxextents unlimited
    pctincrease 0


Popular posts from this blog

finding fragmentation at table level and tablespace level in Oracle and steps to remove them

ORA-01153: an incompatible media recovery is active standby database oracle

ORA-16191: Primary log shipping client not logged on standby