datafile CANNOT be taken to offline!

From: <ibm_97_at_yahoo.com>
Date: Tue, 08 Feb 2000 22:47:35 GMT
Message-ID: <87q6e5$838$1@nnrp1.deja.com>

Oracle 8i for solaris 2.6

I try to drop tablespace A. Begin with 'alter tablespace A offline'. 'svrmgrl' returns: 'datafile B already be offline, bring it ONLINE first', then I do 'alter database datafile B online;', 'svrmgrl' returns 'ORA-01113: datafile B needs media recovery'. But I don't have the backup for this datafile B.

What should I do now? Datafile B is big, and I don't want to waste the space hold by datafile B.

Thanks a lot! Pls cc to me also.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 08 2000 - 16:47:35 CST