Re: Connecting to ops$ account
Date: 1996/04/12
Message-ID: <4kkc46$757_at_norman.cmutual.com.au>#1/1
In article <3168FB96.4983_at_online.ru>, "Roman L. Podshivalov" <romas_at_online.ru> writes:
> Mario Simic wrote:
> >
> > Enrico Soldani (clemnet_at_clemenger.com.au) wrote:
> > : Is it possible to connect to an ops$ account from within SQL*Plus
> > : given that I'm logged on as another user. For example, I'm logged
> > : on as dba, I enter SQL*Plus and connect as SYSTEM and now want to
> > : connect as ops$fred. How can I do this without exiting SQL*Plus?
> >
> > If you are on UNIX you must escape $ character:
> > connect OPS\$FRED/OPS\$FRED
>
> It doesnot work...
This is wrong. On Unix, you will need to escape the $ only at the Unix shell level (where it would be evaluated), not at the sqlplus level. So connect ops$fred/passwd will work. Remember to specify the instance if it differs from $ORACLE_SID.
-- * * * * * * * * * * * * * * dave * DSylva_at_colonial.com.au * * * * * * * * * * * * * * * std disclaimers apply...Received on Fri Apr 12 1996 - 00:00:00 CEST