SQL> select  c.owner ||','||c.table_name ||'('||c.column_name||')-'|| c.data_typ                       e ||''col
from dba_tab_cols c,dba_objects o where c.data_type like '% WITH TIME ZONE' and                        c.owner=o.owner
and c.table_name=o.object_name
and o.object_type='TABLE'
order by col
/  2    3    4    5    6

COL
--------------------------------------------------------------------------------
DBSNMP,MGMT_DB_FEATURE_LOG(LAST_UPDATE_DATE)-TIMESTAMP(6) WITH TIME ZONE
IX,AQ$_ORDERS_QUEUETABLE_L(DEQUEUE_TIME)-TIMESTAMP(6) WITH TIME ZONE
IX,AQ$_ORDERS_QUEUETABLE_S(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
IX,AQ$_ORDERS_QUEUETABLE_S(DELETION_TIME)-TIMESTAMP(6) WITH TIME ZONE
IX,AQ$_ORDERS_QUEUETABLE_S(MODIFICATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
IX,AQ$_STREAMS_QUEUE_TABLE_L(DEQUEUE_TIME)-TIMESTAMP(6) WITH TIME ZONE
IX,AQ$_STREAMS_QUEUE_TABLE_S(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
IX,AQ$_STREAMS_QUEUE_TABLE_S(DELETION_TIME)-TIMESTAMP(6) WITH TIME ZONE
IX,AQ$_STREAMS_QUEUE_TABLE_S(MODIFICATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,ALERT_QT(SYS_NC00029$)-TIMESTAMP(0) WITH TIME ZONE
SYS,AQ$_ALERT_QT_L(DEQUEUE_TIME)-TIMESTAMP(6) WITH TIME ZONE

COL
--------------------------------------------------------------------------------
SYS,AQ$_ALERT_QT_S(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_ALERT_QT_S(DELETION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_ALERT_QT_S(MODIFICATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_AQ$_MEM_MC_L(DEQUEUE_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_AQ$_MEM_MC_S(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_AQ$_MEM_MC_S(DELETION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_AQ$_MEM_MC_S(MODIFICATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_AQ_PROP_TABLE_L(DEQUEUE_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_AQ_PROP_TABLE_S(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_AQ_PROP_TABLE_S(DELETION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_AQ_PROP_TABLE_S(MODIFICATION_TIME)-TIMESTAMP(6) WITH TIME ZONE

COL
--------------------------------------------------------------------------------
SYS,AQ$_KUPC$DATAPUMP_QUETAB_1_L(DEQUEUE_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_KUPC$DATAPUMP_QUETAB_1_S(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_KUPC$DATAPUMP_QUETAB_1_S(DELETION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_KUPC$DATAPUMP_QUETAB_1_S(MODIFICATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_KUPC$DATAPUMP_QUETAB_L(DEQUEUE_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_KUPC$DATAPUMP_QUETAB_S(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_KUPC$DATAPUMP_QUETAB_S(DELETION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_KUPC$DATAPUMP_QUETAB_S(MODIFICATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_SCHEDULER$_EVENT_QTAB_L(DEQUEUE_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_SCHEDULER$_EVENT_QTAB_S(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_SCHEDULER$_EVENT_QTAB_S(DELETION_TIME)-TIMESTAMP(6) WITH TIME ZONE

COL
--------------------------------------------------------------------------------
SYS,AQ$_SCHEDULER$_EVENT_QTAB_S(MODIFICATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_SCHEDULER$_REMDB_JOBQTAB_L(DEQUEUE_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_SCHEDULER$_REMDB_JOBQTAB_S(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_SCHEDULER$_REMDB_JOBQTAB_S(DELETION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_SCHEDULER$_REMDB_JOBQTAB_S(MODIFICATION_TIME)-TIMESTAMP(6) WITH TIME ZON
E

SYS,AQ$_SCHEDULER_FILEWATCHER_QT_L(DEQUEUE_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_SCHEDULER_FILEWATCHER_QT_S(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_SCHEDULER_FILEWATCHER_QT_S(DELETION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_SCHEDULER_FILEWATCHER_QT_S(MODIFICATION_TIME)-TIMESTAMP(6) WITH TIME ZON

COL
--------------------------------------------------------------------------------
E

SYS,AQ$_SUBSCRIBER_TABLE(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_SUBSCRIBER_TABLE(DELETION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_SUBSCRIBER_TABLE(MODIFICATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_SYS$SERVICE_METRICS_TAB_L(DEQUEUE_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_SYS$SERVICE_METRICS_TAB_S(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_SYS$SERVICE_METRICS_TAB_S(DELETION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,AQ$_SYS$SERVICE_METRICS_TAB_S(MODIFICATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,FGR$_FILE_GROUPS(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,FGR$_FILE_GROUP_FILES(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE

COL
--------------------------------------------------------------------------------
SYS,FGR$_FILE_GROUP_VERSIONS(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,KET$_AUTOTASK_STATUS(ABA_START_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,KET$_AUTOTASK_STATUS(ABA_STATE_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,KET$_AUTOTASK_STATUS(MW_RECORD_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,KET$_AUTOTASK_STATUS(MW_START_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,KET$_AUTOTASK_STATUS(RECONCILE_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,KET$_CLIENT_CONFIG(FIELD_2)-TIMESTAMP(6) WITH TIME ZONE
SYS,KET$_CLIENT_CONFIG(LAST_CHANGE)-TIMESTAMP(6) WITH TIME ZONE
SYS,KET$_CLIENT_TASKS(CURR_WIN_START)-TIMESTAMP(6) WITH TIME ZONE
SYS,KET$_CLIENT_TASKS(LG_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,KET$_CLIENT_TASKS(LT_DATE)-TIMESTAMP(6) WITH TIME ZONE

COL
--------------------------------------------------------------------------------
SYS,OPTSTAT_HIST_CONTROL$(SPARE6)-TIMESTAMP(6) WITH TIME ZONE
SYS,OPTSTAT_HIST_CONTROL$(SVAL2)-TIMESTAMP(6) WITH TIME ZONE
SYS,OPTSTAT_USER_PREFS$(CHGTIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,REG$(NTFN_GROUPING_START_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,REG$(REG_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_EVENT_LOG(LOG_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_EVENT_QTAB(SYS_NC00032$)-TIMESTAMP(0) WITH TIME ZONE
SYS,SCHEDULER$_EVENT_QTAB(SYS_NC00044$)-TIMESTAMP(0) WITH TIME ZONE
SYS,SCHEDULER$_EVENT_QTAB(SYS_NC00045$)-TIMESTAMP(0) WITH TIME ZONE
SYS,SCHEDULER$_FILEWATCHER_HISTORY(LAST_CHECK_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_FILEWATCHER_RESEND(INS_TSTAMP)-TIMESTAMP(6) WITH TIME ZONE

COL
--------------------------------------------------------------------------------
SYS,SCHEDULER$_FILE_WATCHER(LAST_MODIFIED_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_GLOBAL_ATTRIBUTE(ATTR_TSTAMP)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_JOB(END_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_JOB(LAST_ENABLED_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_JOB(LAST_END_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_JOB(LAST_START_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_JOB(NEXT_RUN_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_JOB(START_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_JOB_DESTINATIONS(LAST_ENABLED_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_JOB_DESTINATIONS(LAST_END_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_JOB_DESTINATIONS(LAST_START_DATE)-TIMESTAMP(6) WITH TIME ZONE

COL
--------------------------------------------------------------------------------
SYS,SCHEDULER$_JOB_DESTINATIONS(NEXT_START_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_JOB_RUN_DETAILS(LOG_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_JOB_RUN_DETAILS(REQ_START_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_JOB_RUN_DETAILS(START_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_LIGHTWEIGHT_JOB(END_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_LIGHTWEIGHT_JOB(LAST_ENABLED_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_LIGHTWEIGHT_JOB(LAST_END_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_LIGHTWEIGHT_JOB(LAST_START_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_LIGHTWEIGHT_JOB(NEXT_RUN_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_LIGHTWEIGHT_JOB(START_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_REMDB_JOBQTAB(SYS_NC00041$)-TIMESTAMP(0) WITH TIME ZONE

COL
--------------------------------------------------------------------------------
SYS,SCHEDULER$_REMDB_JOBQTAB(SYS_NC00042$)-TIMESTAMP(0) WITH TIME ZONE
SYS,SCHEDULER$_REMOTE_JOB_STATE(LAST_END_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_REMOTE_JOB_STATE(LAST_START_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_REMOTE_JOB_STATE(NEXT_START_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_SCHEDULE(END_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_SCHEDULE(REFERENCE_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_STEP_STATE(END_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_STEP_STATE(START_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_WINDOW(ACTUAL_START_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_WINDOW(END_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_WINDOW(LAST_START_DATE)-TIMESTAMP(6) WITH TIME ZONE

COL
--------------------------------------------------------------------------------
SYS,SCHEDULER$_WINDOW(MANUAL_OPEN_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_WINDOW(NEXT_START_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_WINDOW(START_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_WINDOW_DETAILS(LOG_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_WINDOW_DETAILS(REQ_START_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER$_WINDOW_DETAILS(START_DATE)-TIMESTAMP(6) WITH TIME ZONE
SYS,SCHEDULER_FILEWATCHER_QT(SYS_NC00033$)-TIMESTAMP(0) WITH TIME ZONE
SYS,TSM_DST$(DST_END_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,TSM_DST$(DST_INST_START_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,TSM_DST$(DST_START_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,TSM_SRC$(SRC_END_TIME)-TIMESTAMP(6) WITH TIME ZONE

COL
--------------------------------------------------------------------------------
SYS,TSM_SRC$(SRC_INST_START_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,TSM_SRC$(SRC_START_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRI$_ALERT_HISTORY(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRI$_ALERT_HISTORY(TIME_SUGGESTED)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRI$_ALERT_OUTSTANDING(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRI$_ALERT_OUTSTANDING(TIME_SUGGESTED)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRI$_OPTSTAT_AUX_HISTORY(SAVTIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRI$_OPTSTAT_AUX_HISTORY(SPARE6)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRI$_OPTSTAT_HISTGRM_HISTORY(SAVTIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRI$_OPTSTAT_HISTGRM_HISTORY(SPARE6)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRI$_OPTSTAT_HISTHEAD_HISTORY(SAVTIME)-TIMESTAMP(6) WITH TIME ZONE

COL
--------------------------------------------------------------------------------
SYS,WRI$_OPTSTAT_HISTHEAD_HISTORY(SPARE6)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRI$_OPTSTAT_IND_HISTORY(SAVTIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRI$_OPTSTAT_IND_HISTORY(SPARE6)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRI$_OPTSTAT_OPR(END_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRI$_OPTSTAT_OPR(SPARE6)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRI$_OPTSTAT_OPR(START_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRI$_OPTSTAT_TAB_HISTORY(SAVTIME)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRI$_OPTSTAT_TAB_HISTORY(SPARE6)-TIMESTAMP(6) WITH TIME ZONE
SYS,WRR$_REPLAY_DIVERGENCE(TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,AQ$_MGMT_LOADER_QTABLE_L(DEQUEUE_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,AQ$_MGMT_LOADER_QTABLE_S(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE

COL
--------------------------------------------------------------------------------
SYSMAN,AQ$_MGMT_LOADER_QTABLE_S(DELETION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,AQ$_MGMT_LOADER_QTABLE_S(MODIFICATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,AQ$_MGMT_NOTIFY_QTABLE_L(DEQUEUE_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,AQ$_MGMT_NOTIFY_QTABLE_S(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,AQ$_MGMT_NOTIFY_QTABLE_S(DELETION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,AQ$_MGMT_NOTIFY_QTABLE_S(MODIFICATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,MGMT_PROV_ASSIGNMENT(LAST_MODIFIED_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,MGMT_PROV_ASSIGNMENT(START_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,MGMT_PROV_BOOTSERVER(LAST_MODIFIED_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,MGMT_PROV_CLUSTER_NODES(LAST_MODIFIED_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,MGMT_PROV_DEFAULT_IMAGE(LAST_MODIFIED_TIME)-TIMESTAMP(6) WITH TIME ZONE

COL
--------------------------------------------------------------------------------
SYSMAN,MGMT_PROV_IP_RANGE(LAST_MODIFIED_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,MGMT_PROV_NET_CONFIG(LAST_MODIFIED_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,MGMT_PROV_OPERATION(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,MGMT_PROV_OPERATION(LAST_MODIFIED_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,MGMT_PROV_RPM_REP(LAST_MODIFIED_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,MGMT_PROV_STAGING_DIRS(LAST_MODIFIED_TIME)-TIMESTAMP(6) WITH TIME ZONE
SYSMAN,MGMT_PROV_SUITE_INST_MEMBERS(LAST_MODIFIED_TIME)-TIMESTAMP(6) WITH TIME Z
ONE

WMSYS,AQ$_WM$EVENT_QUEUE_TABLE_L(DEQUEUE_TIME)-TIMESTAMP(6) WITH TIME ZONE
WMSYS,AQ$_WM$EVENT_QUEUE_TABLE_S(CREATION_TIME)-TIMESTAMP(6) WITH TIME ZONE

COL
--------------------------------------------------------------------------------
WMSYS,AQ$_WM$EVENT_QUEUE_TABLE_S(DELETION_TIME)-TIMESTAMP(6) WITH TIME ZONE
WMSYS,AQ$_WM$EVENT_QUEUE_TABLE_S(MODIFICATION_TIME)-TIMESTAMP(6) WITH TIME ZONE
WMSYS,WM$VERSIONED_TABLES(SYS_NC00020$)-TIMESTAMP(0) WITH TIME ZONE
WMSYS,WM$VERSIONED_TABLES(SYS_NC00021$)-TIMESTAMP(0) WITH TIME ZONE

163 rows selected.

SQL>



SQL> select distinct c.owner from dba_tab_cols c,dba_objects o
where c.data_type like'%WITH TIME ZONE'
and c.owner=o.owner
and c.table_name=o.object_name
and o.object_type='TABLE'
order by 1
/  2    3    4    5    6    7

OWNER
------------------------------
DBSNMP
IX
SYS
SYSMAN
WMSYS

SQL>