DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: changing the oracle system date for testing applications

  1. #1
    Join Date
    Oct 2007

    changing the oracle system date for testing applications

    Hopefully you guys can help me out

    im am currently i am in the process of testing an oracle database application in particular Oracle HR suite.
    To test the oracle HR database we will be cutting test data from the live production system. however been told by resident oracle experts that there might be issues in cutting the production data for testing purposes ( ie we have a exact instance of oracle application in test environment as in production)
    the following example was given as the issues we might face

    (i) If we take a cut of the oracle production data on 5th Oct 2007 and start testing in Jan 2007, the oracle processes that need to run for all the records for 4 weeks with dates before the system date , hence these processes wouldnt run because processes/functions in oracle are system date sensitive

    as further explained below

    the system date is in Jan 2007 and the data cut is from Oct 5 2007. so will need to alter the system date, such that oracle thinks it is in Novemeber not Jan 2007. Hence would therefore pick up data records from Oct 2007 and populate our test environment instance of the application

    guys im not an oracle expert but doing this sounds complicated is there a easy and fail safe method to overcome this issue somehow.

  2. #2
    Join Date
    Apr 2007

    Try the OS

    Oracle reads the date of the Operating system,Try changing the operating system date

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