修改系統時間對oracle資料庫的影響

renjixinchina發表於2015-01-29
原文網址 : http://blog.itpub.net/15747463/viewspace-1419095/
Oracle資料庫
1. It will affect any records that are inserted while changing the date if it involves the sysdate.

2. It will also affect any scheduler jobs that will run on that date.

Please follow those steps :

1. Take a backup
2. Shutdown database (clean)
3. Change date/time on OS
4. Startup database

參考559660.1

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/15747463/viewspace-1419095/，如需轉載，請註明出處，否則將追究法律責任。

相關文章