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 : 20-08-2017
ORA-14000

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

  • ora-32840 : property name cannot be NULL
  • ora-27094 : raw volume used can damage partition table
  • ora-13620 : The task or object string is read-only and cannot be deleted or modified.
  • ora-29359 : invalid method name string specified for resource plan string
  • ora-09927 : Unable to set label of server
  • ora-04013 : number to CACHE must be less than one cycle
  • ora-13370 : failure in applying 3D LRS functions
  • ora-12432 : LBAC error: string
  • ora-07495 : spwat: lm_wait failed.
  • ora-30196 : reserved for future use
  • ora-29915 : cannot select FOR UPDATE from collection operand
  • ora-30044 : 'Retention' can only specified for undo tablespace
  • ora-30351 : query rewrite does not currently support this expression
  • ora-06445 : ssvpstevrg: Incorrect parameters passed to function call
  • ora-01596 : cannot specify system in string parameter
  • ora-26664 : cannot create STREAMS process string
  • ora-16796 : one or more properties could not be imported from the database
  • ora-30572 : AUTO segment space management not valid with DICTIONARY extent management
  • ora-13052 : unsupported geometric type for geometry string.string
  • ora-00409 : COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT
  • ora-06259 : NETNTT: cannot read from remote process
  • ora-02313 : object type contains non-queryable type string attribute
  • ora-27078 : unable to determine limit for open files
  • ora-24087 : Invalid database user string
  • ora-00272 : error writing archive log string
  • ora-26675 : cannot create Streams capture process string
  • ora-24399 : invalid number of connections specified
  • ora-38447 : Type required for the embedded ADT attribute "string" is missing
  • ora-19686 : SPFILE not restored due to string
  • ora-24274 : no row exists in the string table for these parameters
  • 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.