Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: datafile CANNOT be taken to offline!
First thing u need to make sure is that your database is in archivelog mode
or not. Since u say u don't have backups I assume that ur database is in
NoArchivelog. Then try the following command.
Alter database <datafilename> offline drop.
That should do it
--
Murali
If u haven't crashed your server you haven't worked enough"
<ibm_97_at_yahoo.com> wrote in message news:87q6e5$838$1_at_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 - 20:00:22 CST