Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / guest

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)

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01967: invalid option for CREATE CONTROLFILE

3 Answers   Oracle,


ORA-00109: invalid value for attribute string: string

1 Answers  


ORA-27461: The value for attribute string is too large.

1 Answers  


RMAN-08588: converted datafile=string

1 Answers  


RMAN-07502: List of Files Unknown to the Database

1 Answers  






ORA-03204: the segment type specification should indicate partitioning

1 Answers  


QSM-02179: MV with UNION ALL requires compatibility >= 9.2

1 Answers  


SQL*Loader-00253: DB2 partition number has no significance -- ignored

1 Answers  


NNL-00276: Trace level is now number

1 Answers  


ORA-28274: No ORACLE password attribute corresponding to user nickname exists.

1 Answers  


ORA-39035: Data filter string has already been specified.

1 Answers  


ORA-12203: TNS:unable to connect to destination

1 Answers  






Categories