Re: drop user cascade

From: <lkj741_at_my-deja.com>
Date: Fri, 01 Sep 2000 11:58:46 GMT
Message-ID: <8oo5ld$a06$1@nnrp1.deja.com>

I think user has a active job running. if you do (UNIX) ps -eaf|sort you might be able to see it...

In article <mjm.967762546_at_fraser>,
mjm_at_barwonwater.vic.gov.au (Michael McGarrigle) wrote:
> I am noticing that running a
> "drop user cascade" on one of our databases is taking over 15 hours.
> There are many tables in the database but 15 hours sounds excessive.
> Does anyone have any ideas on what I may be able to do to speed this
up?
>
> TIA
>
> --
> Michael McGarrigle mjm_at_barwonwater.vic.gov.au
> Information Systems Barwon Water
> 61-67 Ryrie St Geelong Phone: +61 352 262326
> Victoria 3220 Australia Fax: +61 352 218236
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 01 2000 - 06:58:46 CDT