Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
ALL_TSTZ_TABLES
displays information about the tables accessible to the current user, which have columns defined on TIMESTAMP WITH TIME ZONE
data types or object types containing attributes of TIMESTAMP WITH TIME ZONE
data types.
DBA_TSTZ_TABLES
displays information about all tables in the database, which have columns defined on TIMESTAMP WITH TIME ZONE
data types or object types containing attributes of TIMESTAMP WITH TIME ZONE
data types.
USER_TSTZ_TABLES
displays information about the tables owned by the current user, which have columns defined on TIMESTAMP WITH TIME ZONE
data types or object types containing attributes of TIMESTAMP WITH TIME ZONE
data types. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the table |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the table |
UPGRADE_IN_PROGRESS |
VARCHAR2(3) |
Indicates whether a table upgrade is in progress (YES ) or not (NO ) |
See Also: