ORA-29363: plan directive string, string is mandatory and cannot be modified or deleted

Cause : An attmept wasm ade tom odify amandatroy pland irectiev.

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

Do nota ttemptt o modiyf mandaotry pla ndirectvies becuase the yare reuqired b ythe Reosurce Mnaager adn canno tbe modfiied.

update : 25-04-2017
ORA-29363

ORA-29363 - plan directive string, string is mandatory and cannot be modified or deleted
ORA-29363 - plan directive string, string is mandatory and cannot be modified or deleted

  • ora-12711 : this CREATE CONTROLFILE character set is not allowed
  • ora-40291 : model cost not available
  • ora-34145 : (MXCGPUT03) You cannot use the APPEND keyword with SURROGATE workspace object.
  • ora-36667 : (XSDPART05) string is not a legal CONCAT partition.
  • ora-27060 : could not set close-on-exec bit on file
  • ora-19707 : invalid record block number - string
  • ora-38760 : This database instance failed to turn on flashback database
  • ora-32021 : parameter value longer than string characters
  • ora-25141 : invalid EXTENT MANAGEMENT clause
  • ora-04003 : sequence parameter string exceeds maximum size allowed (string digits)
  • ora-32032 : free temporary object number not available
  • ora-00037 : cannot switch to a session belonging to a different server group
  • ora-31497 : invalid value specified for first_scn
  • ora-12071 : definition query of "string"."string" is invalid for offline instantiation
  • ora-39210 : A PCTSPACE adjustment of string is invalid.
  • ora-12019 : master table is a synonym to a remote object
  • ora-06108 : NETTCP: connect to host failed
  • ora-07255 : spini: cannot set up signal handler.
  • ora-32590 : log group specification not allowed here
  • ora-27028 : skgfqcre: sbtbackup returned error
  • ora-13901 : Object string was not found.
  • ora-13707 : Either the start snapshot string or the end snapshot string is incomplete or missing key statistics.
  • ora-32406 : cannot alter partitioning for existing materialized view log
  • ora-39958 : invalid warning category qualifier
  • ora-22315 : type "string" does not contain a map or order function
  • ora-35282 : (SNSYN166) The format of the AGGREGATE function is: AGGREGATE(varname USING aggmap-name [COUNTVAR intvar-name] [FORCECALC])
  • ora-04072 : invalid trigger type
  • ora-16242 : Processing logfile (thread# string, sequence# string)
  • ora-28027 : privileged database links may be used by global users
  • ora-01183 : cannot mount database in SHARED mode
  • 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.