Problem taking datafile offline.

From: <vdolt_at_my-deja.com>
Date: Thu, 28 Sep 2000 21:00:20 GMT
Message-ID: <8r0bgu$nr2$1@nnrp1.deja.com>

I run Oracle 8.0.5 on NT.
One of my datafiles (5 total) that compromise data tablespace got corrupted. Because I have a full export I wanted to drop tablespace and reimport the data.
I was planning to mount database, take datafile offline, open database, drop tablespace.
1. I mounted database and issued alter database datafile offline. Message I got stated - "Unable to take datafile offline unless media recovery enabled"
What does it mean, what do I need to enable to take datfile offline?

Thank you.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 28 2000 - 16:00:20 CDT