ORA-14640: add/coalesce index partition operation is valid
only for hash partitioned global indexes



ORA-14640: add/coalesce index partition operation is valid only for hash partitioned global indexes..

Answer / guest

Cause: User attempted to add or coalesce an index partition
of a global index not partitioned by hash method.

Action: Issue the statement on a global index partitioned by
hash method. or if the index is partitioned by range method
consider using split/drop instead of add/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-19018: Invalid character in XML tag 'string'

1 Answers  


RMAN-03031: this option of set command needs to be used inside a run block

1 Answers  


ORA-01952: system privileges not granted to 'string'

1 Answers  


QSM-02021: set operator encountered in mv

1 Answers  


ORA-29501: invalid or missing Java source, class, or resource name

1 Answers  






ORA-09369: Windows 3.1 Two-Task driver bad instance handle

1 Answers  


ORA-12675: External user name not available yet

1 Answers  


RMAN-06711: global scripts require a target connection

1 Answers  


ORA-30000: missing either trim specification or char expression in TRIM

1 Answers  


ORA-01114: IO error writing block to file string (block # string)

1 Answers  


CLSS-00103: unable to read configuration information for node string

1 Answers  


ORA-01106: database must be closed before dismounting

1 Answers  


Categories