This discussion is archived
3 Replies Latest reply: Nov 11, 2013 10:12 PM by Vedant.. RSS

ora-25176: storage specification not permitted for primary key during alter index nologging

User560461-OC Newbie
Currently Being Moderated

Hi All,

 

We have some indexes with nologging. We want DML on all indexes to be logged.So i tried to change the index to logging using "alter index indexname logging" syntax. It failed with below error:

 

alter index OASIS.PK_V_APLUS_OBI_INV_PIPE_ARR logging

*

ERROR at line 1:

ORA-25176: storage specification not permitted for primary key

 

Index DDL statement:

 

  CREATE UNIQUE INDEX "OASIS"."PK_V_APLUS_OBI_PIPELINEEMPL" ON "OASIS"."V_APLUS_

OBI_PIPELINEEMPL" ("PIPELINEID", "OFFCODE")

  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING

  STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

  TABLESPACE "TS_OASIS_1M".

 

Need help in resolving issue.

 

thanks

Sandeep

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points