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-13618: The value string is not a valid value for procedure argument string.

1 Answers  


PCC-00099: Length cannot be given for types ROWID, DATE, or MLSLABEL

1 Answers  


ORA-31198: Mismatch in number of bytes transferred due to non-binary mode

1 Answers  


EXP-00091: Exporting questionable statistics.

1 Answers  


KUP-04007: end of file reached

1 Answers  






ORA-06027: NETASY: channel close failure

1 Answers  


ORA-06132: NETTCP: access denied, wrong password

1 Answers  


ORA-01255: cannot shutdown - file string in recovery manager backup

1 Answers  


EXP-00095: Flashback_time and Flashback_scn are not compatible

1 Answers  


ORA-09218: sfrfs: failed to refresh file size

1 Answers  


ORA-13624: The task string is executing and cannot be deleted or modified.

1 Answers  


ORA-19561: %s requires a DISK channel

1 Answers  


Categories