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 : 20-08-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-16406 : Primary and standby database software version mismatch
  • ora-32312 : cannot refresh a secondary materialized view "string"."string"
  • ora-31449 : invalid value for change_set_name
  • ora-25020 : renaming system triggers is not allowed
  • ora-14622 : Value string already exists in subpartition string
  • ora-25960 : join index cannot be based on a temporary table
  • ora-27197 : skgfprs: sbtpcrestore returned error
  • ora-04095 : trigger 'string' already exists on another table, cannot replace it
  • ora-25260 : AQ latch cleanup testing event
  • ora-22984 : view query cannot contain references to a super view
  • ora-09824 : Unable to enable allowmacaccess privilege.
  • ora-28349 : cannot encrypt the specified column recorded in the materialized view log
  • ora-16773 : error starting Redo Apply
  • ora-12537 : TNS:connection closed
  • ora-36997 : (XSRELGID14) For variable or relation grouping ids, a level relation is needed when a level order valueset is specified.
  • ora-24430 : Null values for sqltext and key were specified.
  • ora-13638 : The user interrupted the current operation.
  • ora-25143 : default storage clause is not compatible with allocation policy
  • ora-36982 : (XSRELGID03) The grouping variable/relation workspace object must be dimensioned by all dimensions of the source relation workspace object that have more than one value in status.
  • ora-01581 : attempt to use rollback segment (string) new extent (string) which is being allocated
  • ora-32315 : REFRESH FAST of "string"."string" unsupported after mixed DML and Direct Load
  • ora-01214 : MAXLOGHISTORY may not exceed string
  • ora-23609 : unable to find directory object for directory string
  • ora-36692 : (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [levelorder lovs] [inhierarchy {variable | valueset}].
  • ora-30575 : ConText Option not installed
  • ora-24336 : invalid result set descriptor
  • ora-02783 : Both post and wait functions were not specified
  • ora-00089 : invalid instance number in ORADEBUG command
  • ora-02335 : invalid datatype for cluster column
  • ora-27411 : empty string is not a valid repeat interval.
  • 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.