Re: How to drop a datafile from tablespace?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 Aug 2004 06:47:13 -0700
Message-ID: <2687bb95.0408190547.18cc0c25@posting.google.com>

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.

Forgive this if this is a duplicate. I got an error on the post attemp. When that happens sometimes the post makes it and someitmes it doesn't.

Basically if you add a datafile to a tablespace by mistake or with the wrong parameters the only way to remove the file from the tablespace and to have the tablespace still be accessible with versions 6.0 - 9.2 is to re-create the tablespace.

Been there, done that. It is a bit of a pain.

HTH -- Mark D Powell -- Received on Thu Aug 19 2004 - 08:47:13 CDT