Re: Clean up datafiles

info_at_Boecker-OCP.com (Yukonkid) wrote in message news:<ed737cdd.0410052333.498bd0d6_at_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

select * from dba_temp_files; if you do that, so you don't go "gee, nothing has bothered with this file, I guess I'll delete it," and crash the next time Oracle does a big sort.

jg

--
@home.com is bogus.
All your base are mine!