Re: Did I do this the correct way?

That works. Because it was a tempoary tablespace, you didn't have to worry about losing data. Another approach you could have taken was to restore the database and do an incomplete recovery.

Jantah wrote in message <385fbc3f.460376_at_news1.a2000.nl>...
>Had a bit of trouble on one of our databases the other day. We decided
>it would be best torestore a backup of the database. No problem,
>untill we discovered that the backup script skips one disk.
>Fortunately, this disk only holds a datafile for a temporary
>tablespace (phew...).
>
>Anyway, I am stuck with a database with one datafile out of sync with
>the control files. So this is what I did:
>
>- Mount the database.
>- Use alter database to take the datafile offline.
>- Open the database.
>- Drop the temporary tablespace.
>- Re-create the temporary tablespace, re-using the old files.
>
>All is fine now, but I wonder if had also been possible to just drop
>and re-create the datafile, instead of the entire tablespace.
>
>(Running Oracle 7.3.3 on Solaris)
>
>Thanks in advance
>--
>Jan
>jantah_at_big.hand.com
>(replace big.hand with bigfoot to email Jan)
Received on Wed Dec 22 1999 - 08:13:56 CST