DBA_UNUSED_COL_TABS

Oracle 11gR1

DBA_UNUSED_COL_TABS describes all tables in the database containing unused columns. Its columns are the same as those in ALL_UNUSED_COL_TABS.

Related Views

· ALL_UNUSED_COL_TABS describes the tables accessible to the current user that contain unused columns.

· USER_UNUSED_COL_TABS describes the tables owned by the current user that contain unused columns. 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 table
COUNT	NUMBER		Number of unused columns

Oracle data dictionary views