Re: Remove Datafile from database

From: Phil Cook <pncook_at_mindspring.com>
Date: 2000/03/09
Message-ID: <8a9cr5$o32$1@slb6.atl.mindspring.net>#1/1

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 Thu Mar 09 2000 - 00:00:00 CST