Re: Dropping Users That Are Currently Connected / Killing Sessions

On Mon, 28 Jun 2004 15:04:48 -0600, Lee <now_at_yjo.se> wrote:

>Hi there,
>
>I wonder if someone can me an idea of how to get around the following
>problem? I run regression tests each night using Junit/DbUnit, where
>each test drops the user, recreates the user, creates the schema,
>enables constraints, populated the tables, etc. I often use DBVisualizer
>to browse the tables, but often forget to disconnect before I go home.
>It seems that DBVisualizer doesn't have an auto-disconnect, so when the
>tests run, they all fails giving the message, ~"cannot drop user that is
>currently connected". It's no big deal to just disconnect every night,
>but silly me forget about 2 times a week.
>
>Can anyone direct me to some URLs, where it might give me an idea of how
>to disconnect a user / kill the session in a script?
>
>Many thanks in advance,
> Lee

Look up the net8 documentation under Dead Connection Detection, or CREATE profile for setting up an idle time, or ... just read the fine manual.

--
Sybrand Bakker, Senior Oracle DBA