Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem taking datafile offline.
Have you firstly issued the command ?:
drop tablespace (tablespace name) including contents
This will drop all the objects from that tablespace and then teh tablespcae itself. Once this is done you can use the command:
alter database datafile 'path&filename' offline drop
You will need to do this for all datafiles for that tablespace.
run a select on dba_data_files to check to see if these files appear in the list. Once gone you can then temporarily rename the datafiles from the operating system and try and shutdown and restart your database to ensure all is O.K. If so, delete the datafiles from teh operating system. Hope this helps.
Stuart
<vdolt_at_my-deja.com> wrote in message news:8r0bgu$nr2$1_at_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 Fri Sep 29 2000 - 06:04:58 CDT