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

Maybe the import put some of your tables back into the old tablespace by default? If you still have the export dmp file around you can run an import with the SHOW=Y parameter to verify whether or not they were really exported. If the tables are in that export file you can re-import them.
Regardless, don't hang yourself, I believe that you may still have a future as an application developer!

Mary Travis
DBA
EDS holger_at_object-factory.REMOVETHIS.com (Holger Hoffstaette) wrote:

>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

Mary Travis
BellSouth Telecommunications
email: Mary.B.Travis_at_bridge.bellsouth.com Received on Fri Jan 09 1998 - 00:00:00 CST