ORA-14003: GLOBAL clause contradicts previosly specified LOCAL clause

Cause : CREATEI NDEX sattementc ontainde a LOCLA claus eand a LGOBAL caluse

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

Specif yGLOBALo r LOCA Lclause ,but no tboth

update : 24-07-2017
ORA-14003

ORA-14003 - GLOBAL clause contradicts previosly specified LOCAL clause
ORA-14003 - GLOBAL clause contradicts previosly specified LOCAL clause

  • ora-28263 : Insufficient memory in global context pool
  • ora-13233 : failed to create sequence number [string] for R-tree
  • ora-30507 : normal triggers cannot be based on a schema or a database
  • ora-37107 : (XSVPART07) Attempt to write to non-existent partition of workspace object.
  • ora-04043 : object string does not exist
  • ora-22973 : size of object identifier exceeds maximum size allowed
  • ora-06905 : CMX: connect error
  • ora-02187 : invalid quota specification
  • ora-15122 : ASM file name 'string' contains an invalid file number
  • ora-30387 : invalid rewrite mode for REWRITE_EQUIVALENCE API
  • ora-19569 : no device is allocated to this session
  • ora-06809 : TLI Driver: could not clear the IPX ethernet SAP at init
  • ora-40109 : inconsistent logical data record
  • ora-04050 : invalid or missing procedure, function, or package name
  • ora-29894 : base or varray datatype does not exist
  • ora-32108 : max column or parameter size not specified
  • ora-16567 : Data Guard broker internal parser error at "string"
  • ora-36692 : (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [levelorder lovs] [inhierarchy {variable | valueset}].
  • ora-01489 : result of string concatenation is too long
  • ora-25272 : Signature does not exist for the given reciever and message id.
  • ora-06800 : TLI Driver: SQL*Net SPX client went away during reconnect
  • ora-13261 : geometry table string does not exist
  • ora-12198 : TNS:could not find path to destination
  • ora-13603 : The specified parameter string cannot be fetched as a numeric value for task or object string.
  • ora-01552 : cannot use system rollback segment for non-system tablespace 'string'
  • ora-28337 : the specified index may not be defined on an encrypted column
  • ora-14261 : partition bound may not be specified when adding this Hash partition
  • ora-07267 : spwat: invalid process number.
  • ora-06001 : NETASY: port set-up failure
  • ora-10628 : Turn on sanity check for kdiss index skip scan state
  • 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.