How to change Sysdate of Oracle Database - Page 4
DBAsupport.com Forums - Powered by vBulletin
Page 4 of 4 FirstFirst ... 234
Results 31 to 33 of 33

Thread: How to change Sysdate of Oracle Database

  1. #31
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by gdinakar
    Dude
    I think forum is for DBAs, not for politicians. No one is expert. We are all trying to find solution to something they didn't have exposure to or to something they have expertise in.
    So, I will continue to read all the things that U call "CRAP". If U don't want to read all that, pls get the heck out of this forum.
    Hope U got it. Edison had to take 2000 attempts before inventing electirc bulb. So, I don't think U R super human to figure out things at first shot.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  2. #32
    Join Date
    Feb 2003
    Posts
    40
    Hello,
    There is a chance that from where you are invoking sqlplus is having OS date different to that of the date set in the Unix machine where database actually resides.

    Eg : There are 2 Unix machines A & B
    B is where database(ABCD) resides..
    A is where you invoke SQL+ as
    sqlplus @ABCD.WORLD
    In A it is set as '5 feb 2003'
    In B it is set as '10 Feb 2003'.

    Then when u give select sysdate from dual;Output would be '10 Feb2003'
    But when you give
    Sql>!date
    5 feb 2003.

    Confirm from select host_name from v$instance;

    I don't know if I am throwing light or blowing light.
    Jus' thinking from a different angle.that's all..

    With lots of fun,
    Chithra
    K.Chithra
    Oracle DBA

  3. #33
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by stmontgo
    hilarity ensues as a one post reply answer gets exploded to 3 pages of wasted space
    Make that 4 pages of wasted space...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width