Re: how to open db with bad tablespace

try the following:

startup mount
alter database datafile '<the file you removed then touched>' offline drop; alter database open
create a new tablespace and move all objects from the screwed up TS into the new one (if the datafile was empty like you said, you should be able to do this)
drop the old tablespace

hope that works for you

-- 
Posted from [63.83.225.245] 
via Mailgate.ORG Server - http://www.Mailgate.ORG