Re: Clean up datafiles

yelellav wrote:

> 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.

1. SELECT file_name FROM dba_data_files;

Then make sure they are gone.

But far better:

2. DROP TABLESPACE <tablespace_name>

    INCLUDING CONTENTS AND DATAFILES
    CASCADE CONSTRAINTS;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)