Multiple log-in profiles

[Ruby]

Hi There,
Please help.
I access a 9i and a 10g database via PL/SQL.
Everytime I switch between the two, I have to go Tools/Preferences/customise - make my change to the relevant home directory/apply/ log out/ log back in and off I go again.
Is there no way I can set up a shortcut for each profile? The above method is very time-consuming and open to error, as I have to keep on remembering where I was last (not that I ever know where I am anyway).

Thanks a lot.

Ruby

 

[Marco Kalter]

You can create 2 shortcuts for this and pass the Oracle Home name on the command-line. For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" oraclehome=OraHome92

The actual Oracle Home names can be found in the selection list on the Oracle/Connection page of the PL/SQL Developer preferences.

For more information about command-line parameters, see chapter 24.4 in the User's Guide.

 

[Joachim Rupik]

Or, you can use Oracle Locator Express - a small free utility with which you can switch the default Oracle Home on-the-fly, just like the Oracle Home Selector does.

Just let PL/SQL Developer autodetect an Oracle Home and before opening a new PL/SQL Developer instance simply change Oracle Home using this tool from system tray.

Greetings,
Joachim Rupik