How to use the Dictionary Views

DESCRIBE DICTIONARY;

Name	Null?	Type
TABLE_NAME		VARCHAR2(30)
COMMENTS		VARCHAR2(4000)

SELECT * FROM dictionary WHERE table_name = 'USER_OBJECT'

	COMMENTS
USER_OBJECTS	Objects owned by the user

The Dictionary view contains the name and short description of each dictionary view to which you have access. From the dictionary view, you can find what kinds of views are in the Oracle database.

The names in the data dictionary are uppercase.

USER_OBJECTS and ALL_OBJECTS Views

OBJECT_NAME	OBJECT_TYPE	CREATED	STATUS
PMYKEY_ID	INDEX	24-NOV-06	VALID
DEPT_NAME_INDEX	INDEX	27-NOV-06	VALID
LOC_COUNTRY_IX	INDEX	23-NOV-06	VALID
LOC_STATE_PROVINCE_IX	INDEX	23-NOV-06	VALID
LOC_CITY_IX	INDEX	23-NOV-06	VALID
JHIST_DEPARTMENT_IX	INDEX	23-NOV-06	VALID
JHIST_EMPLOYEE_IX	INDEX	23-NOV-06	VALID
JHIST_JOB_IX	INDEX	23-NOV-06	VALID
DEPT_LOCATION_IX	INDEX	23-NOV-06	VALID

............................

USER_OBJECTS:
- OBJECT_NAME
- OBJECT_ID : Dictionary object number  for the object
- OBJECT_TYPE : TABLE, VIEW, INDEX, SEQUENCE, and so on.)
- CREATED : Timestamp
- LAST_DDL_TIME : last modification timestamp
- STATUS : valid, invalid, or N/A
- GENERATED : Is system-generated object? (yes or not)

• Objects owned by you.
• A useful way to obtain a listing of all object names and types in your schema, plus the following information:
  - Data created
  - Date of last modification
  - Status (valid or invalid)

ALL_OBJECT

• To see all objects to which you have access.