Oracle PL/SQL/System Tables Views/dict

get a complete list of all the data dictionary views

 
SQL>
SQL> select * from dict
  2  where rownum < 50;
TABLE_NAME
------------------------------
COMMENTS
--------------------------------------------------
ALL_XML_SCHEMAS
Description of all XML Schemas that user has privi
lege to reference
ALL_XML_SCHEMAS2
Dummy version of ALL_XML_SCHEMAS that does not hav
e an XMLTYPE column
DBA_ROLES
All Roles which exist in the database
DBA_PROFILES
Display all profiles and their limits
USER_RESOURCE_LIMITS
Display resource limit of the user
USER_PASSWORD_LIMITS
Display password limits of the user
USER_CATALOG
Tables, Views, Synonyms and Sequences owned by the
 user
ALL_CATALOG
All tables, views, synonyms, sequences accessible
to the user
DBA_CATALOG
All database Tables, Views, Synonyms, Sequences
USER_CLUSTERS
Descriptions of user"s own clusters
ALL_CLUSTERS
Description of clusters accessible to the user
DBA_CLUSTERS
Description of all clusters in the database
USER_CLU_COLUMNS
Mapping of table columns to cluster columns
DBA_CLU_COLUMNS
Mapping of table columns to cluster columns
USER_COL_COMMENTS
Comments on columns of user"s tables and views
ALL_COL_COMMENTS
Comments on columns of accessible tables and views
DBA_COL_COMMENTS
Comments on columns of all tables and views
USER_COL_PRIVS
Grants on columns for which the user is the owner,
 grantor or grantee
ALL_COL_PRIVS
Grants on columns for which the user is the granto
r, grantee, owner,
 or an enabled role or PUBLIC is the grantee
DBA_COL_PRIVS
All grants on columns in the database
USER_COL_PRIVS_MADE
All grants on columns of objects owned by the user
ALL_COL_PRIVS_MADE
Grants on columns for which the user is owner or g
rantor
USER_COL_PRIVS_RECD
Grants on columns for which the user is the grante
e
ALL_COL_PRIVS_RECD
Grants on columns for which the user, PUBLIC or en
abled role is the grantee
DBA_ENCRYPTED_COLUMNS
Encryption information on columns in the database
ALL_ENCRYPTED_COLUMNS
Encryption information on all accessible columns
USER_ENCRYPTED_COLUMNS
Encryption information on columns of tables owned
by the user
USER_DB_LINKS
Database links owned by the user

TABLE_NAME
------------------------------
COMMENTS
--------------------------------------------------
ALL_DB_LINKS
Database links accessible to the user
DBA_DB_LINKS
All database links in the database
DBA_EXP_OBJECTS
Objects that have been incrementally exported
DBA_EXP_VERSION
Version number of the last export session
DBA_EXP_FILES
Description of export files
USER_INDEXES
Description of the user"s own indexes
ALL_INDEXES
Descriptions of indexes on tables accessible to th
e user
DBA_INDEXES
Description for all indexes in the database
USER_IND_COLUMNS
COLUMNs comprising user"s INDEXes and INDEXes on u
ser"s TABLES
ALL_IND_COLUMNS
COLUMNs comprising INDEXes on accessible TABLES
DBA_IND_COLUMNS
COLUMNs comprising INDEXes on all TABLEs and CLUST
ERs
USER_IND_EXPRESSIONS
Functional index expressions in user"s indexes and
 indexes on user"s tables
ALL_IND_EXPRESSIONS
FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES
DBA_IND_EXPRESSIONS
FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLU
STERS
USER_JOIN_IND_COLUMNS
Join Index columns comprising the join conditions
ALL_JOIN_IND_COLUMNS
Join Index columns comprising the join conditions
DBA_JOIN_IND_COLUMNS
Join Index columns comprising the join conditions
USER_OBJECTS
Objects owned by the user
ALL_OBJECTS
Objects accessible to the user
DBA_OBJECTS
All objects in the database
USER_PROCEDURES
Description of the users own procedures

49 rows selected.
SQL>
SQL>
SQL> --