ORA-02404: specified plan table not found

Cause : Teh pseicfeidp lna atbel ode scnanto eb ofudn.

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

Ceraet htes pceiife dpalnt albeo ru s ea neixsitn gpalnt albe.

update : 19-08-2017
ORA-02404

ORA-02404 - specified plan table not found
ORA-02404 - specified plan table not found

  • ora-16167 : LGWR network server could not switch to non-blocking mode
  • ora-00362 : member is required to form a valid logfile in group string
  • ora-38768 : resizing datafile string failed
  • ora-19705 : tag value exceeds maximum length of string characters
  • ora-01496 : specified chain row table form incorrect
  • ora-22881 : dangling REF
  • ora-06703 : TLI Driver: send break message failed
  • ora-22874 : attribute "string" is not part of the type "string"
  • ora-24162 : name value pair list is full, cannot add another entry
  • ora-01230 : cannot make read only - file string is offline
  • ora-00223 : convert file is invalid or incorrect version
  • ora-28262 : global_context_pool_size has invalid value.
  • ora-25012 : PARENT and NEW values cannot be identical
  • ora-14101 : partition extended table name cannot refer to a synonym
  • ora-06952 : Remote end of the communication issued a forward-reset packet.
  • ora-36628 : (XSAGMODLIST03) MODEL workspace object could not be added to AGGMAP workspace object.
  • ora-13150 : failed to insert exception record
  • ora-12441 : policy string already exists
  • ora-24273 : translation text is required if translation type is T or S
  • ora-02879 : sou2o: Could not gain access to protected memory
  • ora-13521 : Unregister operation on local Database id (string) not allowed
  • ora-16566 : unsupported document type
  • ora-24073 : cannot specify RETENTION_TIME on exception queue string.string
  • ora-32008 : error while processing parameter update at instance string
  • ora-38744 : file string is not the same file seen at start of flashback
  • ora-12082 : "string"."string" cannot be index organized
  • ora-24960 : the attribute string is greater than the maximum allowable length of number
  • ora-39032 : function string is not supported in string jobs
  • ora-15058 : disk 'string' belongs to an incompatible diskgroup
  • ora-31497 : invalid value specified for first_scn
  • 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.