Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Clean up datafiles
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