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 : 24-07-2017
ORA-14001

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

  • ora-24128 : partition name specified for a non-partitioned object
  • ora-22310 : ALTER TYPE error. Refer to table "string"."string" for errors
  • ora-23611 : tablespace "string" has more than one data file
  • ora-14518 : partition contains rows corresponding to values being dropped
  • ora-30936 : Maximum number (string) of 'string' XML node elements exceeded
  • ora-32332 : cannot refresh materialized view "string"."string" as type evolution has occured
  • ora-30748 : column string already enabled to store objects of type string.string
  • ora-02072 : distributed database network protocol mismatch
  • ora-15152 : cluster in rolling upgrade
  • ora-15027 : active use of diskgroup "string" precludes its dismount
  • ora-25326 : Array string operation failed for message at index string
  • ora-22879 : cannot use the LOB INDEX clause for partitioned tables
  • ora-12406 : unauthorized SQL statement for policy string
  • ora-04940 : unsupported optimization of Oracle binary, check alert log for more info
  • ora-00471 : DBWR process terminated with error
  • ora-24330 : internal OCI error
  • ora-24421 : OCISessionRelease cannot be used to release this session.
  • ora-01503 : CREATE CONTROLFILE failed
  • ora-01190 : control file or data file string is from before the last RESETLOGS
  • ora-23534 : missing column in materialized view container table "string"."string"
  • ora-38738 : Flashback log file is not current copy.
  • ora-24102 : invalid prefix for generate_job_name
  • ora-31613 : Master process string failed during startup.
  • ora-29702 : error occurred in Cluster Group Service operation
  • ora-19263 : XQ0043 - duplicate namespace prefix string
  • ora-00470 : LGWR process terminated with error
  • ora-28668 : cannot reference mapping table of an index-organized table
  • ora-16187 : LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes
  • ora-25185 : index column other than last can not be specified for INCLUDE clause
  • ora-04085 : cannot change the value of an OLD reference variable
  • 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.