Re: TOAD to 2 servers

From: Geoff M <gmuldoonnospam_at_scu.edu.au>
Date: Tue, 11 Jan 2005 17:02:37 +1100
Message-ID: <MPG.1c4e170a64da74b3989697@news.individual.net>

sybrandb_at_hccnet.nl says...
> On Mon, 10 Jan 2005 22:15:40 -0500, "spiderman"
> <peter_parker_at_home.comt> wrote:
>
> >How can I make TOAD (Tool for Oracle Application Developers) connected to 2
> >Oracle servers 9i and 10g? I've aleady had it connected to a 9i database and
> >now trying to figure out how I can use it to switch to10g database. Please
> >help
> >
>
> Just open a new connection. That's all there is to it.

Make sure your Oracle Client version is compatible with all the database server versions (it should be if you can talk to 9i) and add another entry to your tnsnames.ora file (use a text editor or the Net Configuration Assistant).

I always find it useful to just connect first using SQL+ just to make sure that you've got those bit correct. Older versions of TOAD might have some problems.

Geoff M Received on Tue Jan 11 2005 - 00:02:37 CST