Re: oracle question

I got answer: As of Oracle8i, oracle incorporated all the functionality formerly available in server manager
into sqlplus. So that DBA might use sqlplus to manage activities like startup and shutdwon.

Yi Zhang wrote:

> 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 Fri Jul 13 2001 - 00:33:27 CEST