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-33278: (DBERR09) Analytic workspace string cannot be attached in RW or EXCLUSIVE mode until the changes made and updated in MULTI mode are committed or rolled back.

1 Answers  


ORA-06540: PL/SQL: compilation error

1 Answers  


IMP-00047: unexpected file sequence number; expected number but found number

1 Answers  


TNS-00559: load of Entrust certificate failed

1 Answers  


ORA-33922: (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a time dimension.

1 Answers  






LFI-01507: fwrite() failed(OSD return value = string) in string.

1 Answers  


ORA-30156: Out of disk space

1 Answers  


PCB-00222: Size for host variable string exceeds maximum size

1 Answers  


ORA-04004: MINVALUE must be less than MAXVALUE

1 Answers  


RMAN-02003: unrecognized character: string

1 Answers  


RMAN-08048: channel string: starting incremental level string datafile backupset

1 Answers  


PLS-00656: field 'string' not available in input argument

1 Answers  


Categories