Access to standard data dictionary objects in the Oracle Database is limited, since the security requirements of schema isolation prevent any user from seeing or knowing the existence of other schemas.

The following data dictionary views and synonyms are accessible from the Oracle Database Cloud Schema Service:

• ALL_ALL_TABLES

• ALL_COL_COMMENTS

• ALL_CONS_COLUMNS

• ALL_CONSTRAINTS

• ALL_DEPENDENCIES

• ALL_ERRORS

• ALL_IND_COLUMNS

• ALL_IND_EXPRESSIONS

• ALL_IND_PARTITIONS

• ALL_IND_STATISTICS

• ALL_INDEXES

• ALL_OBJECTS

• ALL_OBJECT_TABLES

• ALL_PLSQL_OBJECT_SETTINGS

• ALL_REFS

• ALL_SEQUENCES

• ALL_SYNONYMS

• ALL_TAB_COLS

• ALL_TAB_COLUMNS

• ALL_TAB_COMMENTS

• ALL_TAB_PARTITIONS

• ALL_TAB_SUBPARTITIONS

• ALL_TABLES

• ALL_TRIGGERS

• ALL_TYPES

• ALL_UPDATABLE_COLUMNS

• ALL_VIEWS

• AUDIT_ACTIONS

• COL

• COLUMN_PRIVILEGES

• DATABASE_COMPATIBLE_LEVEL

• DATABASE_PROPERTIES

• DICTIONARY

• DICT_COLUMNS

• DUAL

• INDEX_HISTOGRAM

• INDEX_STATS

• PRODUCT_COMPONENT_VERSION

• TAB

• NLS_DATABASE_PARAMETERS

• NLS_INSTANCE_PARAMETERS

• NLS_SESSION_PARAMETERS

• ROLE_ROLE_PRIVS

• ROLE_SYS_PRIVS

• ROLE_TAB_PRIVS

• All USER_% views

• V_$TIMEZONE_NAMES

You can also view schema objects in both Oracle SQL Developer and the SQL section of the Oracle Application Express development environment.