Re: oracle question

Try logging on as "internal".

"Yi Zhang" <yzhang_at_cv.net> wrote in message news:3B4CFA10.6829A6FD_at_cv.net...
> After starting SQL*plus in line mode, you issue the shutdown immediate
> command.
> what most likely will happen next?
>
> A. The database dose not shutdown because user have to disconnect.
> B. SQL*plus returns an error saying you need to connect to oracle first.
>
> C. The database shuts dwon.
> D. Nothing happens. SQL*plus is not a line mode tool.
>
> Correct answer is B. I try to shutdown database with system account in
> sqlplus line mode:
>
> SQL> shutdown immediate
> ORA-01031: insufficient privileges
>
> My question is what kinds of priviledges we need to shutdown database?
> I first time to know we can shutdown database in sqlplus!!!
>
> -Roy
>
>
>
>
Received on Thu Jul 12 2001 - 19:17:32 CEST