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-27124: unable to detach from shared memory segment

1 Answers  


ORA-31527: could not find source column string for CDC change table string.string

1 Answers  


KUP-04068: internal error fetching attribute string

1 Answers  


DRG-10602: failed to queue DML change to column string for primary key string

1 Answers  


TNS-04082: %s event string set to string.

1 Answers  






ORA-02147: conflicting SHARED/EXCLUSIVE options

1 Answers  


ORA-39064: unable to write to the log file

1 Answers  


NNL-00013: not performed, permission denied for supplied password

1 Answers  


ORA-01718: BY ACCESS | SESSION clause not allowed for NOAUDIT

2 Answers  


LCD-00203: missing keyword [string]

1 Answers  


PLS-00562: a function must return a type.

1 Answers  


DRG-50944: NEAR operator not supported for theme index

1 Answers  


Categories