HELP (please!): dropped tablespace partially killed other tablespace, too!

From: Holger Hoffstaette <holger_at_object-factory.REMOVETHIS.com>
Date: 1998/01/07
Message-ID: <690d4g$ei5$1@leonie.object-factory.com>#1/1

I'm in deep sh*t and could need a cool hand. I've just dropped a tablespace that was definitely NOT used anymore. An app has been migrated to another tablespace and running fine there for several days. After dropping the old tablespace, the new one (which was created and imported by exporting the old one) is missing some tables! As soon as the old tablespace was dropped, the app barfed and the tables seem to be gone for good, although each tablespace was separated from the other, by using different user names etc. I still have the old .dbf file. RECOVER tablespace <old one> doesn't work ('nothing to do'). Is there any way I can reuse the old data file? Please don't make me hang myself. :-# (I'm on Solaris with 7.3, if it matters).

I'd be extremely thankful for any live-savers.

Holger
holger"at"object-factory.com Received on Wed Jan 07 1998 - 00:00:00 CST