SQL> -- View comment on any tables
SQL>
SQL> SELECT * FROM USER_TAB_COMMENTS where rownum < 50;
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
SYSTEM_PRIVILEGE_MAP TABLE
Description table for privilege type codes. Maps privilege type numbers to type names
TABLE_PRIVILEGE_MAP TABLE
Description table for privilege (auditing option) type codes. Maps privilege (auditing option) type numbers to type names
STMT_AUDIT_OPTION_MAP TABLE
Description table for auditing option type codes. Maps auditing option type numbers to type names
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
RESOURCE_MAP TABLE
Description table for resources. Maps resource name to number
ATEMPTAB$ TABLE
Temporary table whose definition is used internally. Never contains data
SESSION_PRIVS VIEW
Privileges which the user currently has set
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
SESSION_ROLES VIEW
Roles which the user currently has enabled.
ROLE_SYS_PRIVS VIEW
System privileges granted to roles
ROLE_TAB_PRIVS VIEW
Table privileges granted to roles
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
ROLE_ROLE_PRIVS VIEW
Roles which are granted to roles
DBA_ROLES VIEW
All Roles which exist in the database
DBA_PROFILES VIEW
Display all profiles and their limits
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
USER_RESOURCE_LIMITS VIEW
Display resource limit of the user
USER_PASSWORD_LIMITS VIEW
Display password limits of the user
RESOURCE_COST VIEW
Cost for each resource
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
USER_CATALOG VIEW
Tables, Views, Synonyms and Sequences owned by the user
ALL_CATALOG VIEW
All tables, views, synonyms, sequences accessible to the user
DBA_CATALOG VIEW
All database Tables, Views, Synonyms, Sequences
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
USER_CLUSTERS VIEW
Descriptions of user"s own clusters
ALL_CLUSTERS VIEW
Description of clusters accessible to the user
DBA_CLUSTERS VIEW
Description of all clusters in the database
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
USER_CLU_COLUMNS VIEW
Mapping of table columns to cluster columns
DBA_CLU_COLUMNS VIEW
Mapping of table columns to cluster columns
USER_COL_COMMENTS VIEW
Comments on columns of user"s tables and views
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
ALL_COL_COMMENTS VIEW
Comments on columns of accessible tables and views
DBA_COL_COMMENTS VIEW
Comments on columns of all tables and views
USER_COL_PRIVS VIEW
Grants on columns for which the user is the owner, grantor or grantee
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
ALL_COL_PRIVS VIEW
Grants on columns for which the user is the grantor, grantee, owner,
or an enabled role or PUBLIC is the grantee
DBA_COL_PRIVS VIEW
All grants on columns in the database
USER_COL_PRIVS_MADE VIEW
All grants on columns of objects owned by the user
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
ALL_COL_PRIVS_MADE VIEW
Grants on columns for which the user is owner or grantor
USER_COL_PRIVS_RECD VIEW
Grants on columns for which the user is the grantee
ALL_COL_PRIVS_RECD VIEW
Grants on columns for which the user, PUBLIC or enabled role is the grantee
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
DBA_ENCRYPTED_COLUMNS VIEW
Encryption information on columns in the database
ALL_ENCRYPTED_COLUMNS VIEW
Encryption information on all accessible columns
USER_ENCRYPTED_COLUMNS VIEW
Encryption information on columns of tables owned by the user
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
USER_DB_LINKS VIEW
Database links owned by the user
ALL_DB_LINKS VIEW
Database links accessible to the user
DBA_DB_LINKS VIEW
All database links in the database
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
DICTIONARY VIEW
Description of data dictionary tables and views
DICT_COLUMNS VIEW
Description of columns in data dictionary tables and views
DBA_EXP_OBJECTS VIEW
Objects that have been incrementally exported
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
DBA_EXP_VERSION VIEW
Version number of the last export session
DBA_EXP_FILES VIEW
Description of export files
USER_INDEXES VIEW
Description of the user"s own indexes
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
ALL_INDEXES VIEW
Descriptions of indexes on tables accessible to the user
DBA_INDEXES VIEW
Description for all indexes in the database
USER_IND_COLUMNS VIEW
COLUMNs comprising user"s INDEXes and INDEXes on user"s TABLES
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
ALL_IND_COLUMNS VIEW
COLUMNs comprising INDEXes on accessible TABLES
49 rows selected.
SQL>
