SQL Developer (MOSC)

MOSC Banner

ORA-00904 in SQL Developer when running DBMS_AUTO_SQLTUNE.report_auto_tuning_task

in SQL Developer (MOSC) 14 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center