Re: why can I logon in restricted mode?

"Chuck Lucas" <chuck.lucas_at_mspb.gov> wrote in news:b35u8i$89g$1_at_ngspool-d02.news.aol.com:

> I'm running Oracle8i on Solaris 8...
>
> Here's the scenario:
>
> I shutdown (normal) the database.
> I mount the database, but not open it.
> I run my RMAN stuff.
>
> Now, at this point, I want to bring the database up (open it) in
> restricted mode, so I
> can run an export.
>
> I issue (in the order shown):
> alter system enable restricted session;
> alter database <name> open;
>
> Now, when I open another SQL*Plus session, I can log in and do
> whatever I want, i.e. select from tables.
>
> Why, when the database is in restricted mode, can I log in? I'm not
> logging in with a DBA user account--it's just a "normal" user account.
> Yet, I can still log in.
>
> I don't understand....or does restricted mode just mean that I can't
> alter the contents (i.e. issue update/delete commands), but looking is
> just fine?
>
> Much thanx for any assistance/enlightenment you can offer,
> Chuck
>
> P.S. Please cc me at my mail account.
>
>

"ALTER DABABASE OPEN" opens it in unrestricted mode, undoing whatever you did in the previous command. You want to say "ALTER DABABASE OPEN RESTRICT". Received on Fri Feb 21 2003 - 14:33:10 CST