Database Administration (MOSC)

MOSC Banner

DROP USER CASCADE hangs in Oracle 19c

edited Mar 11, 2020 1:28PM in Database Administration (MOSC) 7 commentsAnswered ✓

title says it all, below statement hangs. all objects in the schema dropped but command still hangs. I have also locked the schema and it has zero sessions from gv$sessions

drop user mike_owner cascade;

Anyone have this issue before? Looks like Oracle bug

I'm using

19c RAC 19.4.0.0.0

Linux 7

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