Database Administration (MOSC)

MOSC Banner

drop user cascade results after close connection with hung session

edited Apr 16, 2018 10:38AM in Database Administration (MOSC) 7 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center