Re: How to drop a datafile from tablespace?

From: Romeo Olympia <rolympia_at_hotmail.com>
Date: 19 Aug 2004 02:45:37 -0700
Message-ID: <42fc55dc.0408190145.4a528932@posting.google.com>

You cannot drop just a datafile. Tough luck. :p You can either:

(1) - Create a new tablespace B.
    - Move the data from current tablespace A to new tablespace B.
    - Drop tablespace A.

(2) Or if you're just concerned about all that space you allocated for those new datafiles, you could just try resizing them to be as small as possible. Of course you might not be able to do this if they already contain segments.

HTH. 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.
Received on Thu Aug 19 2004 - 04:45:37 CDT