모든 객체(테이블, 뷰, 동의어, 시퀀스)를 참조할 수 있으며, user_objects 테이블에 나타나는 내용의 부분집합임.
SQL> desc all_catalog;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)
SQL> desc dba_catalog;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)
SQL> select count(*) from all_catalog;
COUNT(*)
----------
25414
SQL> select count(*) from dba_catalog;
COUNT(*)
----------
25414
SQL> desc user_catalog;
Name Null? Type
----------------------------------------- -------- ----------------------------
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)
SQL> select count(*) from user_catalog;
COUNT(*)
----------
3701
SQL>