Dropping user with logged in sessions

Dear group,

I must write an automated procedure to drop an Oracle user/schema (cascade)

The procedure must succeed even if client apps are connected for that schema.

Some clients perform automatic reconnection, and will quickly ( < 30 secs) try to reconnect if they find that the connection is lost.

What is in your opinion the most foolproof way to implement this ?

Thanks much

• Raoul

Oracle 8.1.7.3 and 9.2.0.4
Client connections are over TCP/IP
W 2000/2003 Received on Mon Feb 05 2007 - 23:39:17 CST