Very Computer

I want to delete 45 datafiles from my database.  I have offline dropped
them, and then re-created the controlfiles using an edited copy of the
"backup controlfile to trace" script.  When I run
'select file#, name, status from v$datafile;'
I see the files are now "MISSING" and have a status of RECOVER.  So I
guess that they are still in the data dictionary and missing from the
control file.

How can I cleanly remove these files?

Regards
Tony Adolph

Sent via Deja.com http://www.deja.com/
Before you buy.

Quote:> Greetings All,

> I want to delete 45 datafiles from my database.  I have offline
dropped
> them, and then re-created the controlfiles using an edited copy of the
> "backup controlfile to trace" script.  When I run
> 'select file#, name, status from v$datafile;'
> I see the files are now "MISSING" and have a status of RECOVER.  So I
> guess that they are still in the data dictionary and missing from the
> control file.

> How can I cleanly remove these files?

> Regards
> Tony Adolph

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy.

Did you try dropping the tablespaces associated with the datafiles.

I would assume these datafiles are associated with tablespaces you no
longer need.

Quote:>Greetings All,

>I want to delete 45 datafiles from my database.  I have offline dropped
>them, and then re-created the controlfiles using an edited copy of the
>"backup controlfile to trace" script.  When I run
>'select file#, name, status from v$datafile;'
>I see the files are now "MISSING" and have a status of RECOVER.  So I
>guess that they are still in the data dictionary and missing from the
>control file.

>How can I cleanly remove these files?

>Regards
>Tony Adolph

>Sent via Deja.com http://www.deja.com/
>Before you buy.

I have another 20 or so datafiles in this tablespace that contain data
so I cant drop the tablespace.  But if its the only way then I'll move
the remaining objects into another tablepsace and then drop the
original.

Thanks again,
Tony

Sent via Deja.com http://www.deja.com/
Before you buy.