Switch Database - Set Oracle_SID ??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Switch Database - Set Oracle_SID ??

  1. #1
    Join Date
    Nov 2001
    Posts
    110

    Switch Database - Set Oracle_SID ??

    Dear memeber:
    How do yo switch between databases when you have more than one database. I think there is some command like set Oracle_SID= bdname.
    Is that correct. Can you use this in SQL*Plus enviornment. Thanks.

  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    When using NT, you can set the ORACLE_SID variable. It's also important to verify the PATH. Be sure the Oracle version you want to use comes first in the PATH.

    WHen using unix, you can use '. oraenv' and select an SID available in the /etc/oratab file. This will set the ORACLE_SID and other necessary variables. ( eg. PATH )

    HTH
    Gert

  3. #3
    Join Date
    Aug 2002
    Posts
    176
    In Win NT ,2000 Command prompt

    c:\> set oracle_sid=sid (without spaces between equal symbol)


    will allow you to switch between databases.

    Thanks
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

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