Re: Oracle/Windows Help

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 12 Nov 2002 22:31:46 -0000
Message-ID: <3dd181dc$1_2@mk-nntp-1.news.uk.worldonline.com>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:cdHz9.74273$g9.209005_at_newsfeeds.bigpond.com...
>
> "Jake" <me_at_heyjay.com> wrote in message
> news:aqnbka$812$1_at_bob.news.rcn.net...
> > One last gotcha,
> >
> > After you:
> > set ORACLE_SID=yourInstance
> >
> > you have to use " if you want to use sqlplus to login as sysdba
> > a la:
> >
>
>
> Well, you don't exactly "have" to.
>
> C:\>sqlplus /nolog
> SQL>connect / as sysdba
>
> But yes, if you want to do it all in one go, then the quotes are required.
>
> Regards
> HJR
>

Just to amplify Howard's remarks:
sqlplus "/ as sysdba" in windoze (sorry, Sybrand) is the equivalent of sqlplus '/ as sysdba' in unix, all other things being equal.

Doesn't seem too much of a problem to me; and at least we've got rid of this 'svrmgrl' and 'connect internal' stuff.

Regards,
Paul Received on Tue Nov 12 2002 - 16:31:46 CST