Newbie: Deleted Datafiles!

I'm probably up the creek without a paddle here, but I thought I'd give it a shot...

On Oracle 7.3.4 running on AIX 4.3.2, the physical files for some tablespaces have been erased. There is no backup. Data loss is not a problem, as they didn't have anything useful in them, but I'm not able to drop the tablespaces.

I know I'm doing it out of sequence, but I was of the impression that they'd already been dropped. I only found out they hadn't when I tried to create them again and got told that they already existed.

Can anybody help out with a "quick fix"? My current thought is to nuke the whole instance, as it's not a big job to recreate it just yet.

If you have a better plan, please let me know.

TIA,

---
Pb
My opinions are my own and should not be taken as
representing any other group or entity.


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