ORA-14001: LOCAL clause contradicts previosly specified GLOBAL clause

Cause : RCAEETI DNXEs atetemtnc noatnidea G OLAB Llcuaesa dna L COLAc alsue

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

pScefi yOLAC LroG OLAB Llcuaes ,ub ton tobht

update : 20-09-2017
ORA-14001

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

  • ora-34296 : (MXDCL36) A NUMBER dimension must be defined with a fixed precision and scale, using the form NUMBER(precision) or NUMBER(precision, scale).
  • ora-07445 : exception encountered: core dump [string] [string] [string] [string] [string] [string]
  • ora-26679 : operation not allowed on LOB or LONG columns in LCR
  • ora-29277 : invalid SMTP operation
  • ora-28537 : no more result sets
  • ora-13360 : invalid subtype in a compound type
  • ora-06106 : NETTCP: socket creation failure
  • ora-14295 : column type or size mismatch between partitioning columns and subpartitioning columns
  • ora-28656 : incomplete attribute specification
  • ora-10663 : Object has rowid based materialized views
  • ora-02075 : another instance changed state of transaction string
  • ora-13435 : GeoRaster metadata dimension inconsistent
  • ora-13186 : fixed tile size tessellation failed
  • ora-23320 : the request failed because of values string and string
  • ora-26503 : internal RepAPI operation failure on object string.string
  • ora-19717 : for non-OMF search the pattern must be specified
  • ora-30364 : this level has the same set of columns as another
  • ora-09779 : snyGetPort: failure to allocate a port.
  • ora-02495 : cannot resize file string, tablespace string is read only
  • ora-38485 : invalid object type for the user-defined function
  • ora-13787 : missing SQL profile for statement object "string" for tuning task "string"
  • ora-27508 : IPC error sending a message
  • ora-06022 : NETASY: channel open failure
  • ora-10700 : Alter access violation exception handler
  • ora-22307 : operation must be on a user-defined type
  • ora-29816 : object being disassociated is not present
  • ora-12505 : TNS:listener does not currently know of SID given in connect descriptor
  • ora-09204 : sfotf: error opening temporary file
  • ora-16157 : media recovery not allowed following successful FINISH recovery
  • ora-22308 : operation not allowed on evolved type
  • 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.