Re: Ordinary Tablespace Drop Hanging

  • From: "Mladen Gogala" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "mgogala@xxxxxxxxx" for DMARC)
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sun, 24 May 2015 21:07:55 -0400

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

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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2015