Re: drop user OEM cascade hangs up

From: Tony Dare <wade.dare_at_oracle.com>
Date: Wed, 21 Apr 2004 14:12:20 -0700
Message-ID: <KDBhc.31$2E2.62@news.oracle.com>

Is the Oracle Management Server still running? If there's a SYSMAN connection active, you won't be able to drop the user. how long does it hang?

Cheers,

Tony Dare
Senior Service Delivery Engineer
Advanced Product Services
Oracle Corporation

note: Opinions expressed here are my own and do not necessarily reflect the views of Oracle Corporation

Hernan Cortez wrote:

> Hello
>
> I try to drop my user OEM (Oracle Enterprise Manager) ...
>
> drop user OEM cascade;
>
> SQL*Plus hangs up. No error messages. No DB activity. No anything.
>
> Could help me some one?
>
>
Received on Wed Apr 21 2004 - 16:12:20 CDT