Oracle change sysdate

In this tutorial, How to change sysdate for Oracle Database server. Oracle gets the system day from OS server data. You can change Oracle SYSDATE for testing. Oracle the essential for DevOps Roles.

Change the Oracle SYSDATE from Oracle DBA

Oracle change SYSDATE.

SQL> ALTER SYSTEM SET fixed_date = '2018-01-28-13:00:00' SCOPE = MEMORY;

Oracle Reset SYSDATE

SQL> ALTER SYSTEM SET fixed_date=NONE;

Beware! Changing Oracle sysdate for testing. After you can reset sysdate for Oracle database server.

Checking the change SYSDATE Oracle.

SQL> select sysdate from dual;

Conclusion

Thought the article, you have used Oracle change sysdate for testing. My topic another  “Install Oracle Database 12c on Centos 7”. I hope will this your helpful.

,

About HuuPV

My name is Huu. I love technology and especially Devops Skill such as Docker, vagrant, git so forth. I likes open-sources. so I created DevopsRoles.com site to share the knowledge that I have learned. My Job: IT system administrator. Hobbies: summoners war game, gossip.
View all posts by HuuPV →

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.