sorry...i mean to disconnect one user...not all users.
"Andre Doehn" <a.doehn_at_gmx.net> schrieb im Newsbeitrag
news:9tj5ks$2sifd$2_at_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:32:27 CST
