How to change the oracle database Time Zone?

set colsep "|"
set linesize 32767
set pagesize 10000
COLUMN PROPERTY_NAME FORMAT A25
COLUMN PROPERTY_VALUE FORMAT A25
COLUMN DESCRIPTION FORMAT A100
SELECT * FROM database_properties;

select dbtimezone from dual;

select sessiontimezone from dual;

export TZ=Asia/Calcutta

emctl config agent getTZ

ALTER DATABASE SET TIME_ZONE='Asia/Calcutta';
OR
ALTER DATABASE SET TIME_ZONE='+05:30';

alter table OE.ORDERS drop column ORDER_DATE ;

SHUTDOWN IMMEDIATE
STARTUP

http://edwinkessels.blogspot.in/2007/02/changing-time-zone-of-database.html

http://jvardhan.blogspot.in/2012/02/hi-all-am-trying-to-understand-what-is.html

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s