Ordinary Tablespace Drop Hanging

From: David Barbour <david.barbour1_at_gmail.com>
Date: Sun, 24 May 2015 15:48:59 -0500
Message-ID: <CAFH+ifd=A6r_9CNRS-becbbeyuPT=e3mYHnPH4FR19FQ9vu9vA_at_mail.gmail.com>

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.

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

Received on Sun May 24 2015 - 22:48:59 CEST

This message: [ Message body ]
Next message: David Barbour: "Fwd: Ordinary Tablespace Drop Hanging - Tablespace is Growing???"
Previous message: MARK BRINSMEAD: "Re: RHEL to CentOS"
Next in thread: David Barbour: "Re: Ordinary Tablespace Drop Hanging"
Maybe reply: David Barbour: "Re: Ordinary Tablespace Drop Hanging"
Reply: Mladen Gogala: "Re: Ordinary Tablespace Drop Hanging"
Reply: Kenneth Fowler: "Re: Ordinary Tablespace Drop Hanging"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message