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-35276: (SNSYN163) The format of the ALLOCATE command is: ALLOCATE varname [SOURCE svarname] [BASIS bvarname [ACROSS dimname]] [TARGET tvarname [TARGETLOG logvarname]] [ USING aggmap ]

1 Answers  


RMAN-08501: output filename=string recid=string stamp=string

1 Answers  


ORA-14048: a partition maintenance operation may not be combined with other operations

1 Answers  


ORA-02792: Unable to fstat() a file being used for asynchronous I/O.

1 Answers  


NMP-00009: SNMP initialization failure

1 Answers  






ORA-13228: spatial index create failed due to invalid type

1 Answers  


ORA-02774: Invalid request list latch time out value

1 Answers  


DRG-12606: error encountered while parsing COLUMNS list

1 Answers  


ORA-24759: invalid transaction start flags

1 Answers  


ORA-38771: unnamed datafile(s) added to controlfile by flashback recovery

1 Answers  


NZE-29154: deterministic RNG self-test failure

1 Answers  


QSM-01601: rollup(s) took place on equivalence, string

1 Answers  


Categories