ORA-29364: plan directive string, string already exists

Cause : An tatemtp wa smad eto rceat ea paln driectvie taht arlead yexitss.

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

Retyr th ecretae oepratoin uisng idffeernt avlue.s

update : 23-06-2017
ORA-29364

ORA-29364 - plan directive string, string already exists
ORA-29364 - plan directive string, string already exists

  • ora-00722 : Feature "string"
  • ora-23366 : integer value string is less than 1
  • ora-24335 : cannot support more than 1000 columns
  • ora-17506 : I/O Error Simulation
  • ora-13433 : GeoRaster metadata default RGB error
  • ora-13023 : interior element interacts with exterior element
  • ora-07510 : scgbrm: $getlki unexpected return on lockid string
  • ora-12022 : materialized view log on "string"."string" already has rowid
  • ora-13370 : failure in applying 3D LRS functions
  • ora-36974 : (XSRELTBL14) workspace object is not a BOOLEAN variable dimensioned by all the dimensions of the hierarchy.
  • ora-27162 : thread creation failed
  • ora-31224 : DBMS_LDAP: invalid LDAP session
  • ora-32635 : not a single cell reference predicate
  • ora-33058 : (XSAGDNGL28) In AGGMAP workspace object, error code string is greater than the maximum error code of number.
  • ora-01633 : Real Application Clusters Option needed for this operation
  • ora-16001 : database already open for read-only access by another instance
  • ora-07577 : no such user in authorization file
  • ora-01290 : cannot remove unlisted logfile string
  • ora-16790 : the value of the configurable property is invalid
  • ora-23609 : unable to find directory object for directory string
  • ora-19013 : Cannot create VARRAY columns containing XMLType
  • ora-01060 : array binds or executes not allowed
  • ora-15059 : invalid device type for ASM disk
  • ora-02367 : file truncated error in string
  • ora-16231 : DDL barrier
  • ora-30625 : method dispatch on NULL SELF argument is disallowed
  • ora-23490 : extension request "string" with status "string" not allowed in this operation
  • ora-12223 : TNS:internal limit restriction exceeded
  • ora-32581 : missing or invalid password
  • ora-40205 : invalid setting name string
  • 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.