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-05-2017
ORA-14016

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-26724 : only SYS is allowed to set the Capture or Apply user to SYS.
  • ora-22990 : LOB locators cannot span transactions
  • ora-37040 : (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.
  • ora-12518 : TNS:listener could not hand off client connection
  • ora-28237 : seed length too short
  • ora-28533 : Heterogeneous Services coercion handling error
  • ora-36280 : (XSCGMDLAGG08) Valueset workspace object does not contain values of any dimension of the current model.
  • ora-13266 : error inserting data into table string
  • ora-16826 : apply service state is inconsistent with the DelayMins property
  • ora-31071 : Invalid database username or GUID string
  • ora-13023 : interior element interacts with exterior element
  • ora-36266 : (XSCGMDLAGG00) Invalid context for the AGGREGATION function
  • ora-31679 : Table data object string has long columns, and longs can not be loaded/unloaded using a network link
  • ora-02852 : Invalid critical-section time out value
  • ora-13018 : bad distance type
  • ora-14501 : object is not partitioned
  • ora-24080 : unschedule_propagation pending for QUEUE string and DESTINATION string
  • ora-02070 : database stringstring does not support string in this context
  • ora-21602 : operation does not support the specified typecode
  • ora-12533 : TNS:illegal ADDRESS parameters
  • ora-31082 : invalid attribute "string" specified in declaration of "string"
  • ora-16091 : dependent archive log destination already archived
  • ora-14641 : STORE-IN clause can be specified only for a Hash, Composite Range Hash table/partition
  • ora-06775 : TLI Driver: error reading break mode
  • ora-16598 : Data Guard broker detected a mismatch in configuration
  • ora-00287 : specified change number string not found in thread string
  • ora-00161 : transaction branch length string is illegal (maximum allowed string)
  • ora-12436 : no policy options specified
  • ora-22877 : invalid option specified for a HASH partition or subpartition of a LOB column
  • ora-06117 : NETTCP: unable to create ORASRV: quota exceeded
  • 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.