Re: Deleting obsolete datafiles

From: Dennis Bieling <dennis.bieling_at_epigenomics.com>
Date: Fri, 14 Nov 2003 14:17:45 +0100
Message-ID: <bp2klp$67b$1@broglie.epigenomics.epi>

Hi !

Sorry, I really forgot to mention the version. I am using 9iR2. The idea with resizing the obsolete datafile to 1 block size is really a nice solution.

Thanks
Dennis

sybrandb_at_yahoo.com wrote:
> 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

-- 
Dennis Bieling
Systemadministrator
Epigenomics AG          www.epigenomics.com           Kastanienallee 24
+493024345404                                              10435 Berlin

Received on Fri Nov 14 2003 - 07:17:45 CST