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

KUP-04055: column string is both a field in the data file and a column transform

1 Answers  


PLS-00425: in SQL, function argument and return types must be SQL type

1 Answers  


ORA-14286: cannot COALESCE the only subpartition of this table partition

1 Answers  


ORA-13502: Cannot rename SYSAUX tablespace

1 Answers  


ORA-29357: object string already exists

1 Answers  






ORA-25197: an overflow segment already exists for the indexed-organized table

1 Answers  


ORA-01525: error in renaming data files

1 Answers  


QSM-01073: materialized view, string, has a join not found in query

1 Answers  


RMAN-06742: platform name 'string' longer than number

1 Answers  


NNL-00558: set|show namesctl_trace_level : set|show the controller's tracing level

1 Answers  


IMG-00860: assert failure, number of region exceeds allocated

1 Answers  


RMAN-06703: could not open file: "string" (reason=string)

1 Answers  


Categories