Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Clean up datafiles

Re: Clean up datafiles

From: Yukonkid <info_at_Boecker-OCP.com>
Date: 6 Oct 2004 00:33:43 -0700
Message-ID: <ed737cdd.0410052333.498bd0d6@posting.google.com>


valleley_at_excite.com (yelellav) wrote in message news:<b7228f17.0410051246.7c04d81b_at_posting.google.com>...
> When you drop a tablespace manually, there is the potential for
> associated datafiles to remain on the OS. I would like to know how I
> can find these datafiles that are no longer associated with a
> tablespace and delete them.
>
> Thanks.

Hi,

files you will not find when you run

select file_name, tablespace_name from dba_data_files;

ciao

yk Received on Wed Oct 06 2004 - 02:33:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US