DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_TSTZ_TABLES

Object Details
Object Name: DBA_TSTZ_TABLES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Description of all tables in the database, which have column(s) defined on timestamp with time zone data type or ADT type containing attribute(s) of timestamp with time zone data type

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128)
Owner of the table
TABLE_NAME VARCHAR2 (128)
Name of the table
UPGRADE_IN_PROGRESS VARCHAR2 (3)
Is table upgrade in progress?
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      TABLE_NAME
,      UPGRADE_IN_PROGRESS
FROM SYS.DBA_TSTZ_TABLES;

Dependencies

[top of page]

SYS.DBA_TSTZ_TABLES references the following:

SchemaSYS
ViewDBA_TSTZ_TAB_COLS
TableOBJ$
TableTAB$
TableUSER$
SYS.DBA_TSTZ_TABLES is referenced by following:

SchemaPUBLIC
SynonymDBA_TSTZ_TABLES