I am looking for a command that will drop a user even if they have an
open connection at the time.

We are using Oracle 8.1.7.4 on AIX. Part of the process is to refresh
the training environment from production, but we are hitting a problem
with DROP USER JOE CASCADE; in the script that runs early in the morning
if 'Joe' has a connection.

DROP TYPE FORCE command is about what I am looking for, but I don't see
that it can be applied to a user, only to user-objects.

One alternative is to script a SHUTDOWN IMMEDIATE; STARTUP; as we really
don't have anything else running on the test instance that needs to
remain up, but I am REALLY leary of scripting database shutdowns.

Thanks for any help...

Walt
Oracle LazyDBA home page