Home -> Usenet -> comp.databases.oracle -> oracle question

oracle question

From: Yi Zhang <yzhang_at_cv.net>
Date: Thu, 12 Jul 2001 01:16:26 GMT
Message-ID: <3B4CFA10.6829A6FD_at_cv.net> 






After starting SQL*plus in line mode, you issue the shutdown immediate
command.


what most likely will happen next?



    
  
  1.   The database dose not shutdown because user have to disconnect.
  
  2.   SQL*plus returns an error saying you need to connect to oracle first.

  
  3.   The database shuts dwon.
  
  4.   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 - 03:16:26 CEST












Original text of this message