ORA-08111: a partitioned index may not be coalesced as a whole

Oracle error message numbers and Oracle error codes.
Post Reply
User avatar
jimb
Site Admin
Posts: 6146
Joined: Thu Jan 19, 2012 1:10 pm
Location: New Delhi, India
Contact:

ORA-08111: a partitioned index may not be coalesced as a whole

Post by jimb »

ORA-08111: a partitioned index may not be coalesced as a whole
Cause: User attempted to coalesce a partitioned index using ALTER INDEX COALESCE statement, which is illegal
Action: Coalesce the index a (sub)partition at a time (using ALTER INDEX MODIFY (sub)PARTITION COALESCE)
Oracle Database Administration Forums
http://www.oracle-forums.com/
xaeresis
Posts: 196117
Joined: Wed Oct 04, 2023 2:39 pm

Re: ORA-08111: a partitioned index may not be coalesced as a whole

Post by xaeresis »

xaeresis
Posts: 196117
Joined: Wed Oct 04, 2023 2:39 pm

Re: ORA-08111: a partitioned index may not be coalesced as a whole

Post by xaeresis »

Post Reply