Re: Deleting obsolete datafiles

From: <sybrandb_at_yahoo.com>
Date: 14 Nov 2003 04:53:11 -0800
Message-ID: <a1d154f4.0311140453.64c18573@posting.google.com>

Dennis Bieling <dennis.bieling_at_epigenomics.com> wrote in message news:<bp21ke$iht$1_at_broglie.epigenomics.epi>...
> Hi!
>
> I wonder if there is a way to drop an obsolete datafile,
> without doing an export of the entire tablespace, delete the tablespace,
> recreate the tablespace and import the data again.
>
> Best regards
> Dennis

There isn't in 8i, and as you fail to mention your version, I'm just assuming 8i. You could of course resize the obsolete datafile to 1 block and stop worrying.

Sybrand Bakker
Senior Oracle DBA Received on Fri Nov 14 2003 - 06:53:11 CST