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

Cause : Usera ttemtped t ocreaet a LCOAL pratitinoed idnex o na no-nparttiione dtabl ewhic his illegal .OnlyG LOBA Lindiecs (pratitinoed o rothewrise)m ay b ecreaetd ona nonp-artiitonedt able.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Corrcet th estatmeent nad reneter

update : 24-06-2017

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

  • ora-38420 : invalid stored attribute sub-expression: string
  • ora-03230 : segment only contains string blocks of unused space above high water mark
  • ora-07497 : sdpri: cannot create trace file 'string'; errno = string.
  • ora-25504 : the system is already in quiesced state
  • ora-19901 : database needs more recovery to create new incarnation
  • ora-26711 : remote table does not contain a primary key constraint
  • ora-26027 : unique index string.string partition string initially in unusable state
  • ora-06503 : PL/SQL: Function returned without value
  • ora-16575 : request terminated at broker discretion
  • ora-28653 : tables must both be index-organized
  • ora-08430 : raw data missing leading sign
  • ora-28221 : REPLACE not specified
  • ora-24081 : compatible parameter needs to be string or greater
  • ora-01070 : Using an old version of Oracle for the server
  • ora-08197 : Flashback Table operation is not supported on clustered tables
  • ora-29962 : fatal error occurred in the execution of ODCIINDEXALTER routine
  • ora-09353 : Windows 32-bit Two-Task driver unable to open event semaphore
  • ora-07232 : slemcc: fclose error.
  • ora-38750 : FLASHBACK DATABASE may not be performed using a dispatcher.
  • ora-04004 : MINVALUE must be less than MAXVALUE
  • ora-12560 : TNS:protocol adapter error
  • ora-13825 : missing SQL statement text for create SQL profile
  • ora-08198 : Flashback Table is not supported on object tables, nested tables
  • ora-06711 : TLI Driver: error on bind
  • ora-09756 : osnpns: no port in the name server.
  • ora-19904 : test recovery not allowed for datafile string
  • ora-27369 : job of type EXECUTABLE failed with exit code: string
  • ora-14507 : partition corrupt. all rows do not fall within partition bounds
  • ora-01956 : invalid command when OS_ROLES are being used
  • ora-39711 : critical patch number less than last installed CPU number
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.