Re: Unused datafiles

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 19 Nov 1999 20:23:33 -0000
Message-ID: <943043221.3035.3.nnrp-14.9e984b29@news.demon.co.uk>

I don't think that you'll be able to drop a datafile without invalidating the tablespace. (But I may be out of date on that one).

If you can drop the unused data files, you could shrink them down to just 2 blocks. The database will know that they are there but will never use them because they are too small to be usable, and they won't be wasting disk space.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Sybrand Bakker wrote in message
<943038777.25412.0.pluto.d4ee154e_at_news.demon.nl>...
>For what is being used and what not, link dba_extents to dba_data_files, or
>dba_free_space to dba_data_files, link them by tablespace_name and/or
>file_id, and you will know the answer.
>You should be able to do an alter database datafile 'xyz' drop, if the file
>is completely empty. Otherwise... Yes!
Received on Fri Nov 19 1999 - 14:23:33 CST