ORA-14505: LOCAL option valid only for partitioned indexes

Cause : nIocrrce tystnxas epicifde

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

eRrt yht eocmmnad

update : 24-06-2017
ORA-14505

ORA-14505 - LOCAL option valid only for partitioned indexes
ORA-14505 - LOCAL option valid only for partitioned indexes

  • ora-13621 : The task_or object string is marked as a template and cannot perform the requested operation.
  • ora-16192 : Primary and standby network integrity mismatch
  • ora-14455 : attempt to create referential integrity constraint on temporary table
  • ora-10700 : Alter access violation exception handler
  • ora-00225 : expected size string of control file differs from actual size string
  • ora-32409 : materialized view log on "string"."string" already excludes new values
  • ora-39601 : Hash key is required.
  • ora-30686 : no dispatcher accepted TCP/IP connection request
  • ora-01227 : log string is inconsistent with other logs
  • ora-33064 : (XSAGDNGL31) In AGGMAP workspace object, the hierarchy dimension QDR workspace object cannot refer to the related dimension of the relation.
  • ora-14134 : indexes cannot use both DESC and REVERSE
  • ora-24026 : operation failed, queue string.string has errors
  • ora-13274 : operator invoked with non-compatible SRIDs
  • ora-04009 : MAXVALUE cannot be made to be less than the current value
  • ora-14322 : DEFAULT partition already exists
  • ora-06919 : CMX: error during write request (unknown event)
  • ora-38457 : The attribute "string" is not a valid XMLType attribute.
  • ora-15155 : version incompatible with the cluster
  • ora-13640 : The current operation was cancelled because it timed out, and was not in interruptible mode.
  • ora-28347 : encryption properties mismatch
  • ora-31694 : master table string failed to load/unload
  • ora-38852 : cannot mark the current instance (redo thread) as disabled
  • ora-31201 : DBMS_LDAP: generic error: string
  • ora-31089 : schema "string" does not target namespace "string"
  • ora-01867 : the interval is invalid
  • ora-01924 : role 'string' not granted or does not exist
  • ora-01159 : file is not from same database as previous files - wrong database id
  • ora-12028 : materialized view type is not supported by master site string
  • ora-09938 : Save of signal handlers failed.
  • ora-28583 : remote references are not permitted during agent callbacks
  • 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.