ORA-14016: underlying table of a LOCAL partitioned index
must be partitioned



ORA-14016: underlying table of a LOCAL partitioned index must be partitioned..

Answer / guest

Cause: User attempted to create a LOCAL partitioned index on
a non-partitioned table which is illegal. Only GLOBAL
indices (partitioned or otherwise) may be created on a
non-partitioned table.

Action: Correct the statement and reenter

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06721: TLI Driver: spurious client req

1 Answers  


ORA-16507: unrecognized request identifier

1 Answers  


DRG-52104: the Oracle Text environment could not initialize

1 Answers  


ORA-37081: Requested advice produced no precomputes

1 Answers  


ORA-22337: the type of accessed object has been evolved

1 Answers  






ORA-16224: Database Guard is enabled

1 Answers  


SQL*Loader-00803: %s field type not supported by External Table

1 Answers  


ORA-29890: specified primary operator does not have an index context

1 Answers  


TNS-00065: INTCTL: Command cannot be executed remotely

1 Answers  


ORA-09842: soacon: Archmon unable to create named pipe.

1 Answers  


ORA-31632: master table "string.string" not found, invalid, or inaccessible

1 Answers  


QSM-01082: Joining materialized view, string, with table, string, not possible

1 Answers  


Categories