ORA-00904 in SQL Developer when running DBMS_AUTO_SQLTUNE.report_auto_tuning_task
When I run DBMS_AUTO_SQLTUNE.report_auto_tuning_task in SQL Developer I get ORA-00904. This also happens in Toad for Oracle. This doesn't happen in Linux SQL*Plus or in Windows SQL*Plus.
How do I fix this?
set lines 222 trim on pages 3333 LONG 1000000
COLUMN parameter_value FORMAT A30
COLUMN parameter_name FORMAT A30
SELECT DBMS_AUTO_SQLTUNE.report_auto_tuning_task
FROM dual;
>> SELECT DBMS_AUTO_SQLTUNE.report_auto_tuning_task
FROM dual
*
Error at line 5
ORA-00904: "DBMS_AUTO_SQLTUNE"."REPORT_AUTO_TUNING_TASK": invalid identifier
SQL Developer Version
Linux SLES 15
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Nov 22 07:56:07 2024