ORA-14000: only one LOCAL clause may be specified

Cause : CREATE INDEX statement contained more than one LOCAL clause

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

Specify LOCAL option at most once

update : 23-05-2017
ORA-14000

ORA-14000 - only one LOCAL clause may be specified
ORA-14000 - only one LOCAL clause may be specified

  • ora-25328 : %s argument size string is smaller than array size
  • ora-09953 : scggc: unexpected return of a lock convert
  • ora-26500 : error on caching "string"."string"
  • ora-15010 : name is already used by an existing ASM disk
  • ora-12734 : Instant Client Light: unsupported client national character set string
  • ora-29975 : Cannot register a query in the middle of an active transaction
  • ora-28510 : heterogeneous database link initialization failed
  • ora-19684 : block media recovery failed because database is suspended
  • ora-16652 : Fast-Start Failover target standby database is disabled
  • ora-13251 : duplicate entry string in metadata table
  • ora-16706 : no resource guard is available
  • ora-29311 : export dump file was not generated by this database, string does not match
  • ora-01260 : warning: END BACKUP succeeded but some files found not to be in backup mode
  • ora-13521 : Unregister operation on local Database id (string) not allowed
  • ora-37075 : (XSMCSESS03) You cannot rename a session-only dimension value.
  • ora-08181 : specified number is not a valid system change number
  • ora-26762 : Cannot autogenerate name for parameter string because of the following reason: string
  • ora-06318 : IPA: Local maximum number of connections exceeded
  • ora-24081 : compatible parameter needs to be string or greater
  • ora-30493 : The percentile value should be a number between 0 and 1.
  • ora-12202 : TNS:internal navigation error
  • ora-30337 : multiple JOIN KEY clauses specified for the same parent level
  • ora-34021 : (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.
  • ora-24076 : cannot perform operation string for NON_PERSISTENT queue string.string
  • ora-01743 : only pure functions can be indexed
  • ora-30487 : ORDER BY not allowed here
  • ora-16013 : log string sequence# string does not need archiving
  • ora-31011 : XML parsing failed
  • ora-06979 : X.25 Driver: server cannot start oracle
  • ora-23398 : user name "string" at database link "string" does not match local user name "string"
  • 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.