How to change Sysdate of Oracle Database - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 33

Thread: How to change Sysdate of Oracle Database

  1. #21
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    not patient, just want to know how far can someone can bull****

  2. #22
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    hilarity ensues as a one post reply answer gets exploded to 3 pages of wasted space
    I'm stmontgo and I approve of this message

  3. #23
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Originally posted by pando
    not patient, just want to know how far can someone can bull****
    Pando, I think you could be here for some time then
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  4. #24
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Closing ceremoney

    ALTER sandycrab RECOVER FROM SYSDATE;


    Thomas
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #25
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    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
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  6. #26
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    133

    Re: Closing ceremoney

    Originally posted by Thomasps
    ALTER sandycrab RECOVER FROM SYSDATE;


    Thomas


    alertlog..
    ----
    Media Recovery Start
    WARNING! Recovering data file sandycrab from a fuzzy file.
    ----


    Giani

  7. #27
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    "fuzzy file" - he has a beard?
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  8. #28
    Join Date
    Feb 2003
    Location
    California, USA
    Posts
    6

    sysdate value

    Hi Sandy
    Can you pls tell us what is the time that you see in OS and what is the time that you see when you select date from oracle db.

    Pls confirm the TZ your OS is showing the time in. Also pls confirm whether you are using sqlplus user/pass@ORACLE_SID.

    Why I am asking all these questions is that is that your query will return different values depending on the TZ setup if you are accessing thru lsnr.

    By default the value in /etc/TIMEZONE is taken. But Otherwise if you set TZ value explicitly when startingup the lsnr, then it will respond with that particular value.

  9. #29
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    how u guys have patientence to read all the crap thing and more over reply.......oops...!!!!!!

    Pando : u wanna know how ppl can be bull****??????

    better go to pak.....
    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"

  10. #30
    Join Date
    Feb 2003
    Location
    California, USA
    Posts
    6

    Angry

    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.

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