Re: Ordinary Tablespace Drop Hanging

From: David Barbour <david.barbour1_at_gmail.com>
Date: Sun, 24 May 2015 16:26:40 -0500
Message-ID: <CAFH+iffdT7jR3tGNkZNE_dp+HbFa68+awYxTLAZPHgtOg+dx+g_at_mail.gmail.com>

Yes - and the business unit running it refuses to upgrade.

I have generated a list of files. and will definitely need to consider stopping this insanity and trying a straight drop. Right now, the used portion of the tablespace is increasing. Which is weird.

Here's the alert log contents - which I'm tailing:

Sun May 24 14:12:20 CDT 2015
drop tablespace psapbtabi including contents and datafiles Sun May 24 14:39:19 CDT 2015
Incremental checkpoint up to RBA [0x25051.18762.0], current log tail at RBA [0x25051.1b5bb.0]
Sun May 24 15:09:26 CDT 2015
Incremental checkpoint up to RBA [0x25051.1b5be.0], current log tail at RBA [0x25051.1eeb6.0]
Sun May 24 15:39:33 CDT 2015
Incremental checkpoint up to RBA [0x25051.1eebe.0], current log tail at RBA [0x25051.2278b.0]
Sun May 24 16:09:38 CDT 2015
Incremental checkpoint up to RBA [0x25051.22797.0], current log tail at RBA [0x25051.27280.0]

On Sun, May 24, 2015 at 4:21 PM, Mark W. Farnham <mwf_at_rsiz.com> wrote:

> I suppose the searching for the datafiles and getting permission to
> actually drop them could be time consuming. Not sure if you have any
> additional alert.log information or information about what the command is
> waiting for.
>
>
>
> I'd suggest losing the "and datafiles" bit (after generating a list of the
> files). After the tablespace becomes unreferenced in Oracle you can
> probably delete the files from the OS unless something has them open.
>
>
>
> 10 is very old, btw.
>
>
>
> mwf
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *David Barbour
> *Sent:* Sunday, May 24, 2015 4:49 PM
> *To:* oracle-l mailing list
> *Subject:* Ordinary Tablespace Drop Hanging
>
>
>
> 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 - 23:26:40 CEST