Database Reference
In-Depth Information
Figure 18.29
Syntax for the
Recycle Bin.
USER_TAB_COMMENTS
and
USER_COL_COMMENTS
.
Comments on table columns.
USER_UNUSED_COL_TABS
. This view shows columns in tables
marked as SET UNUSED and not physically dropped from tables.
DBA_RECYCLEBIN
and
USER_RECYCLEBIN
. These two
metadata views represent all recycle bins for all users and the specific
connected user recycle bin. The RECYCLEBIN view is often referred
to and is simply a synonym for the USER_RECYCLEBIN view. See
Chapter 22 for details on synonyms.
USER_OBJECT_TABLES
. Object type table structures.
USER_TAB_PARTITIONS
and
USER_TAB_SUBPARTITIONS
.
Table partition and subpartition structures.
USER_PART_TABLES
. Table partitioning details of tables at the
partition rather than the table level, as is the case for the
USER_TAB_PARTITIONS and USER_TAB_SUBPARTITIONS
views.
