can't run sql advisor tasks
When I run SQL Access Advisor through the GUI, I get the error ORA-13605: The specified task or object ORA-13605: The specified task or object SQLACCESS1795028 does not exist for the current user. ORA-06512: at "SYS.PRVT_ADVISOR", line 2676 ORA-06512: at "SYS.DBMS_ADVISOR", line 247 ORA-06512: at line 25 does not exist for the current user.
In troubleshooting this, I noticed that there is a query "select count(*) into num_found from user_advisor_sqla_wk_map where task_name = taskname and workload_name = 'SQLACCESS1795028_wkld';" that is not working because user_advisor_sqla_wk_map doesn't exist.
Does anyone know what I need to run to get this created?
Thanks.