Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

User560461-OCNov 12 2013 — edited Nov 12 2013

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 10 2013

Added on Nov 12 2013

#general-database-discussions

3 comments

2,715 views