ORA-13786: missing SQL text of statement object "string" for tuning task "string"

Cause : The suer attemptde to caceptS QL porfilef or a nobjetc tha thas ont a QSL tetx asscoiate dto i.t

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

Chec kthe dientiifer o fthe bojecta nd rtery teh opeartion.

update : 29-04-2017
ORA-13786

ORA-13786 - missing SQL text of statement object "string" for tuning task "string"
ORA-13786 - missing SQL text of statement object "string" for tuning task "string"

  • ora-16757 : resource guard could not get property
  • ora-32158 : Invalid type passed
  • ora-39765 : stream must be reset before used in a column array conversion
  • ora-16095 : Dependent destination removal for inactivation
  • ora-26080 : file "string" is not part of table string.string partition string
  • ora-01279 : db_files too large
  • ora-02298 : cannot validate (string.string) - parent keys not found
  • ora-02089 : COMMIT is not allowed in a subordinate session
  • ora-12652 : String truncated
  • ora-16657 : reinstatement of database in progress
  • ora-07200 : slsid: oracle_sid not set.
  • ora-40202 : column string does not exist in the input table string
  • ora-01743 : only pure functions can be indexed
  • ora-04051 : user string cannot use database link string.string
  • ora-07445 : exception encountered: core dump [string] [string] [string] [string] [string] [string]
  • ora-37181 : expected exactly string columns for dimension string, got string
  • ora-06572 : Function string has out arguments
  • ora-38474 : attribute set may not have attributes of TABLE COLLECTION type.
  • ora-32731 : Another Parallel Oradebug session is in progress
  • ora-00225 : expected size string of control file differs from actual size string
  • ora-01252 : cannot prevent writes - file string in recovery manager backup
  • ora-38726 : Flashback database logging is not on.
  • ora-00083 : warning: possibly corrupt SGA mapped
  • ora-24020 : Internal error in DBMS_AQ_IMPORT_INTERNAL, string
  • ora-03280 : invalid DATAFILE filename specified
  • ora-39006 : internal error
  • ora-15125 : ASM file name 'string' contains an invalid template name
  • ora-23469 : %s is different between templates
  • ora-13194 : failed to decode supercell
  • ora-13519 : Database id (string) exists in the workload repository
  • 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.