ORA-14038: GLOBAL partitioned index must be prefixed



ORA-14038: GLOBAL partitioned index must be prefixed..

Answer / guest

Cause: User attempted to create a GLOBAL non-prefixed
partitioned index which is illegal

Action: If the user, indeed, desired to create a
non-prefixed index, it must be created as LOCAL; otherwise,
correct the list of key and/or partitioning columns to
ensure that the index is prefixed

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25175: no PRIMARY KEY constraint found

1 Answers  


QSM-01565: equivalence, string, cannot compute measure, string, in the query

1 Answers  


QSM-01533: query rewritten with equivalence, string

1 Answers  


RMAN-20204: translation not started

1 Answers  


ORA-30113: error when processing file 'string'

1 Answers  






QSM-01526: query rewrite is disabled for equivalence, string

1 Answers  


ORA-01107: database must be mounted for media recovery

1 Answers  


SQL*Loader-00133: Can't specify both direct path and external tables

1 Answers  


QSM-01522: a more optimal equivlanece than string was used to rewrite

1 Answers  


ORA-26669: parameter string inconsistent with parameter string

1 Answers  


QSM-01567: equivalence, string, cannot support the query measure, string

1 Answers  


ORA-13219: failed to create spatial index table [string]

1 Answers  


Categories