Re: How to drop a datafile from tablespace?

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 19 Aug 2004 12:24:32 GMT
Message-ID: <4_0Vc.4626$QJ3.3340@newssvr21.news.prodigy.com>

sybrandb_at_yahoo.com wrote:

> cnwy_at_263.net (yoke wang) wrote in message news:<42c18ceb.0408182154.5cf02d58_at_posting.google.com>...
>

>>I have added datafiles to a tablespace by mistake.Who can tell me how to drop them?
>>
>>Thanks.
>>
>>Yoke.

>
>
> You can't. Resize them to 0, and learn to live with it.
> BTW A simple search in the manual would have learned you it is not
> possible, because the syntax is lacking. In Oracle there no
> undocumented statements.
>
> Sybrand Bakker
> Senior Oracle DBA

As a corollary to "learn to live with it", learn also to always test changes such as this first in a non-production database where the consequences of a mistake are minimal. A script works much better for this than typing commands in by hand or using a GUI tool such as OEM.

Although the poster asked about datafiles, on a related topic it is possible and safe to drop tempfiles from a temporary tablespace. But that is most likely not the situation at hand.

--Mark Bole Received on Thu Aug 19 2004 - 07:24:32 CDT