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 : 24-05-2017

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

  • ora-31623 : a job is not attached to this session via the specified handle
  • ora-04093 : references to columns of type LONG are not allowed in triggers
  • ora-22369 : invalid parameter encountered in method string
  • ora-06806 : TLI Driver: could not complete protocol initialization for SPX
  • ora-07236 : slemop: open error.
  • ora-00376 : file string cannot be read at this time
  • ora-07250 : spcre: semget error, unable to get first semaphore set.
  • ora-02433 : cannot disable primary key - primary key not defined for table
  • ora-03201 : the group number specification is invalid
  • ora-00164 : distributed autonomous transaction disallowed within migratable distributed transaction
  • ora-07683 : sou2os: $SETPRV reset error
  • ora-24333 : zero iteration count
  • ora-22316 : input type is not a collection type
  • ora-31515 : CDC change source string already exists
  • ora-15183 : ASMLIB initialization error [string]
  • ora-15012 : ASM file 'string' does not exist
  • ora-06577 : output parameter not a bind variable
  • ora-01576 : The instance string is not enabled
  • ora-39092 : unable to set SCN metadata for object "string.string" of type string
  • ora-31218 : DBMS_LDAP: PL/SQL - Invalid LDAP deleteoldrdn.
  • ora-19735 : wrong creation SCN - control file expects initial plugged-in datafile
  • ora-00981 : cannot mix table and system auditing options
  • ora-15082 : ASM failed to communicate with database instance
  • ora-32509 : watchpoint was already deleted
  • ora-15194 : Internal ASM-DB interaction testing event number 15194
  • ora-16638 : could not get the instance status
  • ora-03241 : Invalid unit size
  • ora-21523 : functionality not supported by the server (object mode only)
  • ora-09814 : Unable to expand file name
  • ora-00334 : archived log: '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.