diconnect all user at specific time

From: Andre Doehn <a.doehn_at_gmx.net>
Date: Thu, 22 Nov 2001 16:30:02 +0100
Message-ID: <9tj5ks$2sifd$2@ID-71421.news.dfncis.de>

hi,
i have to import a oracle dump from a another db every night - but for dropping the old schema i have to disconnect all users with this username.
how to disconnect with this specific username?

i dont want to use this way:

>select username, sid, serial# from v$session
>where username = 'X';
>
>(this will give you the information you need to use in the next command to
>kill the session.)
>
>then do
>
>alter system kill session 'sid,serial#'; where you replace sid and serial#
>from the above query.

....because after the system kill session command the session is marked as "killed" and
hold up resources and locks forever until the instance is shut down.

any way around this?

thanks!

andre Received on Thu Nov 22 2001 - 09:30:02 CST