Search notes:

Oracle: Special synonyms for dome data dictionary views

There are some synonyms for a limited set of data dictionary views which can be queried with the following select statement: 
select
   synonym_name,
   table_name
from
   dba_synonyms
where
   table_owner  = 'SYS'          and
   regexp_like(table_name, '^(USER_|ALL_|DBA_)') and
   table_name <> synonym_name
order by
   synonym_name;
ALL_HISTOGRAMS ALL_TAB_HISTOGRAMS
ALL_JOBS USER_JOBS
ALL_OUTLINES USER_OUTLINES
ALL_OUTLINE_HINTS USER_OUTLINE_HINTS
ALL_SNAPSHOT_REFRESH_TIMES ALL_MVIEW_REFRESH_TIMES
CAT USER_CATALOG
CLU USER_CLUSTERS
COLS USER_TAB_COLUMNS
DBA_AUTOSTS_ATTRNAME DBA_AUTOSQLSET_ATTRNAME
DBA_AUTOSTS_OPTENV DBA_AUTOSQLSET_OPTENV
DBA_AUTOSTS_SNAPSHOT DBA_AUTOSQLSET_SNAPSHOT
DBA_AUTOSTS_SNAPSHOT_ERROR DBA_AUTOSQLSET_SNAPSHOT_ERROR
DBA_AUTOSTS_SQLPLAN DBA_AUTOSQLSET_SQLPLAN
DBA_AUTOSTS_SQLSTAT DBA_AUTOSQLSET_SQLSTAT
DBA_AUTOSTS_SQLTEXT DBA_AUTOSQLSET_SQLTEXT
DBA_HISTOGRAMS DBA_TAB_HISTOGRAMS
DBA_LOCKS DBA_LOCK
DBA_SNAPSHOT_LOG_FILTER_COLS DBA_MVIEW_LOG_FILTER_COLS
DBA_SNAPSHOT_REFRESH_TIMES DBA_MVIEW_REFRESH_TIMES
DBA_SQLSET_DEFINITIONS DBA_SQLSET
DBA_XS_ENB_AUDIT_POLICIES DBA_XS_ENABLED_AUDIT_POLICIES
DBA_XS_PRIVILEGE_GRANTS DBA_XS_COLUMN_CONSTRAINTS
IND USER_INDEXES
LOGSTDBY_UNSUPPORTED_TABLES DBA_LOGSTDBY_UNSUPPORTED_TABLE
OBJ USER_OBJECTS
RECYCLEBIN USER_RECYCLEBIN
SEQ USER_SEQUENCES
SYN USER_SYNONYMS
TABS USER_TABLES
USER_HISTOGRAMS USER_TAB_HISTOGRAMS
USER_SNAPSHOT_REFRESH_TIMES USER_MVIEW_REFRESH_TIMES
USER_SQLSET_DEFINITIONS USER_SQLSET

Index