Unable to drop a tablesapace

[pcotten]

I deleted a datafile from the server by mistake. I was deleting some unnecessary custom tablespaces. Deleted the datafile on the server prior to deleting the tablespace on the database. Now I can't drop the tablespace. I don't have a recent backup. We are just using this database to store data for a project. This is not a critical database. But I need to bounce the database after changing the optmizer to CHOOSE from RULE. This is an 8.1.7.4 database. What can I do to successfully drop this tablespace? Thanks.

[gandolf989]

Can you take the tablespace offline, then do an offline drop?

[pcotten]

I tried that but unable to take it offline due to missing datafile.

[davey23uk]

well if you are shutting it down anyway

shutdown

startup mount

alter database datafile 'xxx' offline drop;

alter database open;
drop tablespace yyy including contents and datafiles;