sqlplus sys@orcl as sysdba desc plan_table select object_type, owner from all_objects where object_name = 'PLAN_TABLE'; select * from all_synonyms where synonym_name = 'PLAN_TABLE';If it's not there, you can create it by running the utlxplan.sql script located in the RDBMS/ADMIN folder of your database home (e.g. C:\ora\db10\RDBMS\ADMIN\utlxplan.sql)
grant select_catalog_role to scott; grant select any dictionary to scott;