ORA-14325: only LOCAL indexes may be specified in this clause

Cause : A global index has been specified in the UPDATE INDEXES (..) clause

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

Only specify local indexes when using this clause

update : 29-06-2017

ORA-14325 - only LOCAL indexes may be specified in this clause
ORA-14325 - only LOCAL indexes may be specified in this clause

  • ora-02237 : invalid file size
  • ora-30107 : parameter name abbreviation 'string' is not unique
  • ora-29657 : class defined in EXTERNAL NAME clause is used in another subtype
  • ora-14121 : MODIFY DEFAULT ATTRIBUTES may not be combined with other operations
  • ora-06513 : PL/SQL: index for PL/SQL table out of range for host language array
  • ora-08231 : smscre: unable to attach to SGA
  • ora-29551 : could not convert string to Unicode
  • ora-14271 : table is not partitioned by Composite Range method
  • ora-38304 : missing or invalid user name
  • ora-13382 : geometry metadata (table:string column:string) not found in spatial network:string
  • ora-01673 : data file string has not been identified
  • ora-16095 : Dependent destination removal for inactivation
  • ora-19713 : invalid copy number: string
  • ora-15182 : ASMLIB [string] version mismatch, ORACLE version [string]
  • ora-24390 : Unsupported scrollable cursor operation
  • ora-12329 : database string is closed; no operations are permitted
  • ora-13151 : failed to remove exception record
  • ora-13251 : duplicate entry string in metadata table
  • ora-12067 : empty refresh groups are not allowed
  • ora-00724 : ALTER DATABASE CONVERT command has been de-supported
  • ora-00374 : parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
  • ora-28152 : proxy user 'string' may not specify initial role 'string' on behalf of client 'string'
  • ora-24759 : invalid transaction start flags
  • ora-12602 : TNS: Connection Pooling limit reached
  • ora-24851 : failed to connect to shared subsystem
  • ora-32342 : The EXPLAIN_MVIEW facility failed to explain the materialized view statement
  • ora-27077 : too many files open
  • ora-09793 : szguns: length of user name is greater than buffer.
  • ora-28028 : could not authenticate remote server
  • ora-12505 : TNS:listener does not currently know of SID given in connect descriptor
  • 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.