Re: drop datafile from tablespace

From: Muhammad A. Malik <mamalik_at_cs.wmich.edu>
Date: 1996/05/06
Message-ID: <318E19C1.5BD6_at_cs.wmich.edu>#1/1


Frank Hoerper wrote:
>
> Hi,
>
> (HP 9.x / Oracle 7.0/7.2)
>
> a few days ago I add a datafile to an existing tablespace. It works fine
> and because it was only a test I want to drop/delete the datafile from the
> the tablespace. I don't know exactly the command, because
> I'm not in the office yet, but it was something like
>
> alter tablespace <name> offline drop;
>
> I got the message "Statement processed" but a
> "select * from dba_data_files" shows me, that the datafile was still there.
> But the physical file associated with the datafile was still deleted, so that
> I can't set the tablespace offline. Can someone give me a hint, what I
> have to do, if I wan't delete a datafile from the tablespace. Or is it
> right, that the datafile-entry appears on the select statement after
> dropping the datafile from tablespace ?
>
> bye
> Frank
>
> --
> # Frank Hoerper 51674 Wiehl Tel.: +49 2262 - 68581
> # fh_at_wad.org (privat) hoerper_at_uggk00.ug.eds.com
> # crypt: PGP public key available
>
> --
> # Frank Hoerper 51674 Wiehl Tel.: +49 2262 - 68581
> # fh_at_wad.org (privat) hoerper_at_uggk00.ug.eds.com
> # crypt: PGP public key available

It doesnot matter if dba_data_files shows the file. This file is not invalid for the tablespace.

Nothing will happen if you delete this file from the operating system.

Muhammad A. Malik Received on Mon May 06 1996 - 00:00:00 CEST

Original text of this message