Re: Ordinary Tablespace Drop Hanging

From: sumit Tyagi <dba.tyagisumit_at_gmail.com>
Date: Mon, 25 May 2015 17:24:58 +0530
Message-ID: <CAFW4NVyrd60sdVQeRPOfOZM3NC5eaz0ac86qt2D9wjYxxqGejA_at_mail.gmail.com>

Try after taking the tablespace offline before drop

On Mon, May 25, 2015 at 6:37 AM, Mladen Gogala <dmarc-noreply_at_freelists.org> wrote:

> 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-l
>
>
>

-- 

*--*
*BR*
*Sumit Tyagi*
*+91-7829543355*

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 25 2015 - 13:54:58 CEST