Re: Ordinary Tablespace Drop Hanging
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Sun, 24 May 2015 21:07:55 -0400
Message-ID: <556275EB.2030402_at_yahoo.com>
On 05/24/2015 04:48 PM, David Barbour wrote:
> At least it appears to be.
>
> Oracle 10.2.0.5 on HPUX IA64 11.23.
>
> Issued the 'DROP TABLESPACE XXXXXX INCLUDING CONTENTS AND DATAFILES'
> command 90 minutes ago. It's an old, unmaintained database I'm trying
> to convert to Locally-Managed ASSM tablespaces.
>
> This tablespace has 261 datafiles of varying sizes.
>
> It is NOT going away!
>
> Anybody seen anything like this? Tablespace is currently off-line,
> and has no FK Constraints tied to tables in any other tablespace.
>
What is the wait event you're waiting for?
Date: Sun, 24 May 2015 21:07:55 -0400
Message-ID: <556275EB.2030402_at_yahoo.com>
On 05/24/2015 04:48 PM, David Barbour wrote:
> At least it appears to be.
>
> Oracle 10.2.0.5 on HPUX IA64 11.23.
>
> Issued the 'DROP TABLESPACE XXXXXX INCLUDING CONTENTS AND DATAFILES'
> command 90 minutes ago. It's an old, unmaintained database I'm trying
> to convert to Locally-Managed ASSM tablespaces.
>
> This tablespace has 261 datafiles of varying sizes.
>
> It is NOT going away!
>
> Anybody seen anything like this? Tablespace is currently off-line,
> and has no FK Constraints tied to tables in any other tablespace.
>
What is the wait event you're waiting for?
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Mon May 25 2015 - 03:07:55 CEST