DBA_CATALOG

Oracle 11gR1

DBA_CATALOG lists all tables, views, clusters, synonyms, and sequences in the database. Its columns are the same as those in "ALL_CATALOG".

Related Views

· ALL_CATALOG lists all tables, clusters, views, synonyms, and sequences accessible to the current user.

· USER_CATALOG lists all tables, clusters, views, synonyms, and sequences in the current user's schema. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the TABLE, CLUSTER, VIEW, SYNONYM, SEQUENCE, or UNDEFINED
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the TABLE, CLUSTER, VIEW, SYNONYM, SEQUENCE, or UNDEFINED
TABLE_TYPE	VARCHAR2(11)		Type of the TABLE, CLUSTER, VIEW, SYNONYM, SEQUENCE, or UNDEFINED

Note:

1.

select * from DBA_CATALOG;

OWNER	TABLE_NAME	TABLE_TYPE
SYS	TAB$	TABLE
SYS	USER$	TABLE
SYS	OBJECT_GRANT	SEQUENCE
PUBLIC	STMT_AUDIT_OPTION_MAP	SYNONYM
PUBLIC	V$MAP_FILE	SYNONYM

Oracle data dictionary views