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

Hi,

        No need to get onto that chair (or first floor ledge) just now. Yet, you need to answer for yourself some questions.

        A.) Do you have a complete database backup with the old tablespace before you wiped it out. B.) If not, keep that chair handy. You may need to reconstruct the data from scratch. C.) If you do have the backup (and space is not too constrained and the system can be reasonably brought out of service for some time) you could (and this is only a general blue-print):

1. Backup.
2. Load previous Backup (with old tablespace).
3. Export all data within the old tablespace. (You'll need to know the objects stored here - which if you don't have a list can be had through DBA_TABLES, DBA_INDEXES, etc. www.revealnet.com can help here. Note the space considerations within DBA_TABLESPACE.)
4. Load the Backup in step 1.
5. Recreate the tablespace.
6. Import the objects back into place.

        Obviously, you can change it around on this general theme (depending on space, time & tools available), but that's one way.

        To my knowledge there is no way to simply attach (at the hip as it where) a tablespace that is unrelated (once past the next checkpoint) to an Oracle database.

        Hope this is helpful.

Greg

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
  Received on Thu Jan 08 1998 - 00:00:00 CST