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-00602: internal programming exception

1 Answers  


ORA-13291: conversion error between the specified unit and standard unit

1 Answers  


TNS-00147: Failed to start a pre-spawned pump.

1 Answers  


ORA-27544: Failed to map memory region for export

1 Answers  


ORA-13623: The recommendation string is not valid for task string.

1 Answers  






ORA-36815: (XSTBLFUNC08) The OLAP_TABLE has attempted to use an AW single row function with the aw_attach parameter set to DURATION QUERY.

1 Answers  


ORA-22344: can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change

1 Answers  


ORA-28529: invalid or missing parameter in Net8 service name definition

1 Answers  


ORA-06802: TLI Driver: could not open the /etc/netware/yellowpages file

1 Answers  


LPX-00007: unexpected end-of-file encountered

1 Answers  


ORA-00092: LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC

1 Answers  


RMAN-05514: tablespace string has undo information, cannnot skip

1 Answers  


Categories