DBA_TAB_COMMENTS

Oracle 11gR1

DBA_TAB_COMMENTS displays comments on all tables and views in the database. Its columns are the same as those in ALL_TAB_COMMENTS.

Related Views

· ALL_TAB_COMMENTS displays comments on the tables and views accessible to the current user.

· USER_TAB_COMMENTS displays comments on the tables and views owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
TABLE_TYPE	VARCHAR2(11)		Type of the object
COMMENTS	VARCHAR2(4000)		Comment on the object

Note:

1.

select * from dba_tab_comments;

OWNER	TABLE_NAME	TABLE_TYPE	COMMENTS
SYS	DBA_WARNING_SETTINGS	VIEW	warning settings for all objects
SYS	PRODUCT_COMPONENT_VERSION	VIEW	version and status information for component products
SYS	USER_EVALUATION_CONTEXT_VARS	VIEW	variables in user rule evaluation contexts
SYS	ALL_EVALUATION_CONTEXT_VARS	VIEW	variables in all rule evaluation contexts seen by the user
SYS	DBA_EVALUATION_CONTEXT_VARS	VIEW	variables in all rule evaluation contexts in the database
SYS	USER_TUNE_MVIEW	VIEW	tune_mview catalog view owned by the user

Oracle data dictionary views

Oracle dynamic performance views