Re: Did I do this the correct way?

Yes, you did this the correct way.

Brian

Jantah wrote:
>
> 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 - 09:10:28 CST