Safe, High performance, reuseable

Wednesday, July 26, 2006

Oracle Catalog tables list

ALL_TABLES Information on tables accessible by a user
USER_TABLES Information on tables owned by a user
DBA_TABLES Information on all tables in the database
DBA_SEGMENTS Information about segment storage
DBA_INDEXES Information on all indexes
DBA_USERS Information on all users of the database
DBA_ROLE_PRIVS Information about roles granted
DBA_ROLES Information about roles granted
DBA_SYS_PRIVS Information about system privileges granted
DBA_FREE_SPACE Information about the creation of the database
V$DATABASE Information about the creation of the database
V$SESSION Information on current sessions

No comments: