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.
