Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003

    Unanswered: Time Zone Setting for each schemas.

    Dear All,

    I have created a database having 10 different schemas. Each schema will be accessed to different clients and each clients sits in different countries.
    I want to set the timezone for each schema, so that whenever any client access database, i would like to capture date & time detail of their respective country.

    Thanks in advance
    Thanks and Regards,

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    I don't think you can do it. Oracle obtains timezone information from the OS, and this setting affects the entire instance. It's the application accessing the database that needs to do the conversion.

  3. #3
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    You should be able to accomplish what you desire, if you control the application.
    The application could have added to it a lookup table which contains the location for each client/schema.
    A logon trigger could obtain the approrpiate timezone offset to be used as desired.
    It appears it could be done, but would take some custom programming to accomplish it.
    I doubt the cost vs. benefit ratio would justify changing the s/w to do this.

    HTH & YMMV
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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