Friday, 9 September 2011

ORA-13605: THE SPECIFIED TASK OR OBJECT SYS_AUTO_SQL_TUNING_TASK DOES NOT EXIST

ORA-13605: THE SPECIFIED TASK OR OBJECT SYS_AUTO_SQL_TUNING_TASK DOES NOT EXIST



Solution
run the $ORACLE_HOME/rdbms/admin/execsqlt.sql script



SQL> @$ORACLE_HOME/rdbms/admin/execsqlt.sql

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.
at

3 comments:

  1. Marty27 August 2012 at 15:30

    Solved my problem thank you very much!

    ReplyDelete
  2. idesdemars31 July 2013 at 00:36

    It worked for me too. Had no idea how it was dropped in the first place.

    ReplyDelete
  3. Jack Almond4 July 2020 at 10:03

    Nice Solution .. but i had different scenario of not getting SQL statement in repository itself .. this solution help ..

    http://www.moreajays.com/2020/07/ora-13605-specified-task-or-object-does.html

    ReplyDelete