Re: Shutdown

Diego Pafumi schrieb:
>
> Hi gurus !!!
> I have a question. I have to shutdown my database, but sometimes some
> machines are connected. I want to do a "normal" shutdown. So the
> question is: How can I kill the users connected to my database????
> I saw in the v$session that there are users connected from more than 5
> days, so I want to kill their session.
>

shutdown immediate;	-- Any uncommitted transactions are rolled back,
			-- If this doesn't work use 'shutdown abort'
STARTUP  RESTRICT;	-- will do some instance recovery if necessary
shutdown;		-- 'clean' shutdowned database

HTH
Matthias

-- 
Matthias.Gresz_at_Privat.Post.DE

Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm