3 Replies Latest reply: Nov 12, 2013 12:12 AM by Vedant.. RSS

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

    User560461-OC

      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