drop user cascade results after close connection with hung session
Friend,
one schema have lots of object in database. Can we drop it ( with drop user cascade) when schema is active connecting to database?
The reason for this question is my friend ask me this case. When she run this command (drop user cascade). But scheam user is active connecting to database . She get a hang response status and then close client connection.
As I know ORA-01940: cannot drop a user that is currently connected should be appeared .
But I want to know what kind of result will be happen? partial schema object drop? Or else ?
Thanks