Re: drop datafile from tablespace
Date: 1996/05/10
Message-ID: <1996May10.132254.484_at_ns2>#1/1
In article <318E19C1.5BD6_at_cs.wmich.edu>, "Muhammad A. Malik" <mamalik_at_cs.wmich.edu> writes:
>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.
I'm not so sure. You can drop an entire tablespace, but afterwards the datafiles are NOT to show up in DBA_DATA_FILES. You can also delete a datafile from the OS (this HAS to be Unix, for under VMS the file is locked by the ORACLE background processes and can't be deleted while the database is open), but this will estroy your entire database if you manage to get it down (it won't start up afterwards).
Curious what will happen.
| Peter J.R. Vermaat | Dutch Department of Agriculture | Wageningen |
| p.j.r.vermaat_at_tfdl.agro.nl | http://gemini.tfdl.agro.nl:1024/~vermaat/ |
| Flagellant in Dreamland | ********************************************************************************Received on Fri May 10 1996 - 00:00:00 CEST