ORA-14506: LOCAL option required for partitioned indexes

Cause : Icnorretc ysnatxs pceiifed

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

Rter yteh ocmamnd

update : 26-04-2017

ORA-14506 - LOCAL option required for partitioned indexes
ORA-14506 - LOCAL option required for partitioned indexes

  • ora-36992 : (XSRELGID09) A level relation is needed to produce a surrogate dimension gid.
  • ora-06774 : TLI Driver: error sending break mode
  • ora-12465 : Not authorized for read or write on specified groups or compartments
  • ora-37117 : olapi history retention has been disabled
  • ora-14151 : invalid table partitioning method
  • ora-12659 : Error received from other process
  • ora-03262 : the file is non-empty
  • ora-39025 : jobs of type string are not restartable
  • ora-21705 : service context is invalid
  • ora-22316 : input type is not a collection type
  • ora-02802 : No idle servers available in parallel mode
  • ora-29895 : duplicate base datatype specified
  • ora-28235 : algorithm not available
  • ora-00357 : too many members specified for log file, the maximum is string
  • ora-01632 : max # extents (string) reached in index string.string
  • ora-38484 : FUNCTION/PACKAGE/TYPE string does not exist
  • ora-16070 : parameter string contains an invalid REGISTER attribute value
  • ora-31651 : communication error with master process - detaching job
  • ora-19012 : Cannot convert XML fragment to the required datatype
  • ora-28361 : master key not yet set
  • ora-24790 : cannot mix OCI_TRANS_RESUME and transaction isolation flags
  • ora-08001 : maximum number of sequences per session exceeded
  • ora-12164 : TNS:Sqlnet.fdf file not present
  • ora-27369 : job of type EXECUTABLE failed with exit code: string
  • ora-02708 : osnrntab: connect to host failed, unknown ORACLE_SID
  • ora-24816 : Expanded non LONG bind data supplied after actual LONG or LOB column
  • ora-30394 : source statement identical to the destination statement
  • ora-29660 : Unable to find the class defined in the EXTERNAL NAME clause
  • ora-16659 : failover operation in progress
  • ora-16728 : consistency check for property string found string error
  • 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.