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-29304: tablespace 'string' does not exist

1 Answers  


TNS-00259: Disabled Interchange list:

1 Answers  


ORA-10585: Test recovery can not apply redo that may modify control file

1 Answers  


NNL-00509: set|show cache_checkpoint_interval [<seconds>] [<server_list>] : set|show the server's cache checkpoint interval

1 Answers  


NZE-28757: system attempt to allocate 0 bytes of memory

1 Answers  


ORA-06744: TLI Driver: listener cannot bind

1 Answers  


DRG-12010: This file already exists - replace existing file?

1 Answers  


PCC-02438: Arrays of collection objects are not allowed

1 Answers  


ORA-36978: (XSRELGID01) workspace object must be a self-relation.

1 Answers  


PLS-00400: different number of columns between cursor SELECT statement and return value

1 Answers  


RMAN-06431: recovery catalog created

1 Answers  


PLS-00531: Unsupported type in a VARRAY or TABLE type: 'string'.

1 Answers  


Categories