Re: Remove Datafile from database

Is there any problem with it showing up in v$recoverfile?

Phil Cook wrote:

> No,
>
> If the file is empty, you can do an alter database datafile 'xxx' offline
> drop, but the
> file will still show up v$recoverfile. Look at dba_extents and link the
> file_id back
> to dba_data_files to see if any extents are in that file. Cleanest method
> is
> to export the objects in the tablespace, drop the objects, and re-create the
> tablespace.
>
> Jean-Marc BLAISE wrote in message <8a7t93$q7v$1_at_reader1.fr.uu.net>...
> >Hi,
> >
> >Is there any way to remove datafiles from a tablespace, on ORACLE 8.0.5/NT?
> >
> >I've seen on the storage manager that the option "Remove" exists, but is
> >never validated.
> >
> >Thanks for your help
> >
> >
Received on Fri Mar 10 2000 - 00:00:00 CST