Re: Connecting to ops$ account

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?
 

: Enrico
: --
: Enrico Soldani email: clemnet_at_clemenger.com.au
: Clemenger/BBDO tel: +61 2 9925 5255

Type at your SQL prompt:
connect OPS$FRED/OPS$FRED

If you are on UNIX you must escape $ character: connect OPS\$FRED/OPS\$FRED

I hope it helps.

Mario Simic                    email: masimic_at_public.srce.hr
Zagreb, Croatia                       marios_at_open.hr