| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [SPAM] Oracle and DST changes
I was curious too, so I just went looking for them and it turns out
Oracle's not just pulling our leg - TSTZ is actually used pretty
extensively - 149 columns in 10.2.0.2:
SQL> select owner, table_name, column_name, data_type from dba_tab_columns where data_type like '%ZONE%' order by 1,2,3
OWNER TABLE_NAME COLUMN_NAMEDATA_TYPE
----- ------------------------------ ------------------------------ ------------------------------ SYS ALL_FILE_GROUPS CREATED TIMESTAMP(6) WITH TIME ZONE SYS ALL_FILE_GROUP_VERSIONS CREATED TIMESTAMP(6) WITH TIME ZONE SYS ALL_SCHEDULER_JOBS END_DATE TIMESTAMP(6) WITH TIME ZONE SYS ALL_SCHEDULER_JOBS LAST_START_DATE TIMESTAMP(6) WITH TIME ZONE SYS ALL_SCHEDULER_JOBS NEXT_RUN_DATE TIMESTAMP(6) WITH TIME ZONE SYS ALL_SCHEDULER_JOBS START_DATE TIMESTAMP(6) WITH TIME ZONE SYS ALL_SCHEDULER_JOB_LOG LOG_DATETIMESTAMP(6) WITH TIME ZONE
SYS DBA_AUDIT_TRAIL EXTENDED_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE SYS DBA_COMMON_AUDIT_TRAIL EXTENDED_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE SYS DBA_FGA_AUDIT_TRAIL EXTENDED_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE SYS DBA_FILE_GROUPS CREATED TIMESTAMP(6) WITH TIME ZONE SYS DBA_FILE_GROUP_VERSIONS CREATED TIMESTAMP(6) WITH TIME ZONE SYS DBA_OPTSTAT_OPERATIONS END_TIME TIMESTAMP(6) WITH TIME ZONE SYS DBA_OPTSTAT_OPERATIONS START_TIME TIMESTAMP(6) WITH TIME ZONE SYS DBA_OUTSTANDING_ALERTS CREATION_TIME TIMESTAMP(6) WITH TIME ZONE SYS DBA_OUTSTANDING_ALERTS TIME_SUGGESTED TIMESTAMP(6) WITH TIME ZONE SYS DBA_RESOURCE_INCARNATIONS STARTUP_TIME TIMESTAMP(9) WITH TIME ZONE SYS DBA_SCHEDULER_JOBS END_DATE TIMESTAMP(6) WITH TIME ZONE SYS DBA_SCHEDULER_JOBS LAST_START_DATE TIMESTAMP(6) WITH TIME ZONE SYS DBA_SCHEDULER_JOBS NEXT_RUN_DATE TIMESTAMP(6) WITH TIME ZONE SYS DBA_SCHEDULER_JOBS START_DATE TIMESTAMP(6) WITH TIME ZONE SYS DBA_SCHEDULER_JOB_LOG LOG_DATETIMESTAMP(6) WITH TIME ZONE
SYS DBA_TSM_HISTORY DESTINATION_START_TIME TIMESTAMP(6) WITH TIME ZONE SYS DBA_TSM_HISTORY END_TIME TIMESTAMP(6) WITH TIME ZONE SYS DBA_TSM_HISTORY SOURCE_START_TIME TIMESTAMP(6) WITH TIME ZONE SYS DBA_TSM_HISTORY START_TIME TIMESTAMP(6) WITH TIME ZONE SYS DBA_TSM_SOURCE SOURCE_END_TIME TIMESTAMP(6) WITH TIME ZONE SYS DBA_TSM_SOURCE SOURCE_INSTANCE_START_TIME TIMESTAMP(6) WITH TIME ZONE SYS DBA_TSM_SOURCE SOURCE_START_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 SYS FGR$_FILE_GROUP_VERSIONS CREATION_TIME TIMESTAMP(6) WITH TIME ZONE SYS GV_$XML_AUDIT_TRAIL EXTENDED_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE SYS OPTSTAT_HIST_CONTROL$ SPARE6 TIMESTAMP(6) WITH TIME ZONE SYS OPTSTAT_HIST_CONTROL$ SVAL2 TIMESTAMP(6) WITH TIME ZONE SYS SCHEDULER$_EVENT_LOG LOG_DATETIMESTAMP(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_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$_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 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 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 SYS TSM_SRC$ SRC_INST_START_TIME TIMESTAMP(6) WITH TIME ZONE SYS TSM_SRC$ SRC_START_TIME TIMESTAMP(6) WITH TIME ZONE SYS USER_AUDIT_OBJECT EXTENDED_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE SYS USER_AUDIT_SESSION EXTENDED_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE SYS USER_AUDIT_STATEMENT EXTENDED_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE SYS USER_AUDIT_TRAIL EXTENDED_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE SYS USER_FILE_GROUPS CREATED TIMESTAMP(6) WITH TIME ZONE SYS USER_FILE_GROUP_VERSIONS CREATED TIMESTAMP(6) WITH TIME ZONE SYS USER_SCHEDULER_JOBS END_DATE TIMESTAMP(6) WITH TIME ZONE SYS USER_SCHEDULER_JOBS LAST_START_DATE TIMESTAMP(6) WITH TIME ZONE SYS USER_SCHEDULER_JOBS NEXT_RUN_DATE TIMESTAMP(6) WITH TIME ZONE SYS USER_SCHEDULER_JOBS START_DATE TIMESTAMP(6) WITH TIME ZONE SYS USER_SCHEDULER_JOB_LOG LOG_DATETIMESTAMP(6) WITH TIME ZONE
SQL> select * from v$version;
BANNER
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark
Note that 10g uses timezone aware datatypes in the data dictionary in 10g (or so Oracle claims, I haven't gone looking for them)
Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 22 2007 - 17:02:00 CST
 |
 |