Re: connecting automatically as sys

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Tue, 20 Jul 2004 01:12:49 GMT
Message-ID: <lk_Kc.78503$Rf.16372@edtnps84>

jonathan wrote:

> no.. this is actually a cross-version question. 9.2.0.1 and 8.1.7 and
> come to think of it 7.3.4. OSes are solaris 2.6, 2.8, and windows xp
> tablet edition.
>
> Why confuse the issue with extraneous information that isn't relevent
> to the problem at hand?

Further to this being 'irrelevant' ....

On Oracle9i, if logging in under Unix/Linux from the Unix userid that created the database (at least is the owner of the database), you can enter

sqlplus "/ as sysdba"

I _think_ this is also legit in Windows if done in a DOS box

However, .... since you need this in multiple versions across multiple OSs, my tidbit is indeed extraneous and irrelevant.

/Hans Received on Mon Jul 19 2004 - 20:12:49 CDT