Re: Deleting datafile from tablespace

From: Neil May <amay_at_home.com>
Date: Thu, 11 Feb 1999 05:16:38 GMT
Message-ID: <36C267F7.B49AE721@home.com>

No, of course you can drop the datafile. That has already been done. Oracle has to know that the file existed in case a recovery is performed. The files can be safely removed at the os level and the database restarted.

Regards,
Andrew.

Sang Ryung Lee wrote:
>
> Hi,
>
> There is no way to drop one of the datafiles composed of a
> tablespace.
> You have to drop the temp tablespace and then recreate tablespace.
>
> Though you renamed datafile at OS level, Database still had the old
> information.
> You have to 'alter tablespace rename datafile old to new'
>
> Bye.
>
> Sangryung Lee.
>
Received on Wed Feb 10 1999 - 23:16:38 CST