Hi,
I would like to restore the database from the Enterprise Manager (by clicking the database name, and then take it off line and restoring).
Before restoring i would like to disconnect all existing connections.
I though about using:
alter database <dbname>
set single_user
with rollback immediate
But this command will kill all connections to the <dbname> database except for the connection that I am currently having to the database.
And I will not be able to from the Enterprise Manager.
I also thought about killing all the connection by executing KILL command but the problem is that when there are large number of clients connected some may connect back while killing all the other.
I would like to know a way to kill all connection beside the enterprise manager.
Thanks,
Maya.