ALL_TSTZ_TABLES
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.
Related Views
-
DBA_TSTZ_TABLESdisplays information about all tables in the database, which have columns defined onTIMESTAMP WITH TIME ZONEdata types or object types containing attributes ofTIMESTAMP WITH TIME ZONEdata types. -
USER_TSTZ_TABLESdisplays information about the tables owned by the current user, which have columns defined onTIMESTAMP WITH TIME ZONEdata types or object types containing attributes ofTIMESTAMP WITH TIME ZONEdata types. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the table |
TABLE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the table |
UPGRADE_IN_PROGRESS |
VARCHAR2(3) |
Indicates whether a table upgrade is in progress (YES) or not (NO) |
|
READ_ONLY |
VARCHAR2(3) |
Indicates whether the table upgrade is in READ ONLY mode (YES) or not (NO) |
See Also: