Re: Problem taking datafile offline.

"Stuart Beauchamp" <sbeauchamp_at_btinternet.com> wrote in message news:8r1t3b$3nu$1_at_pheidippides.axion.bt.co.uk...
> Have you firstly issued the command ?:
>
> drop tablespace (tablespace name) including contents
>

Almost certainly he hasn't, because his post says he's in the mount stage. You can't use tablespace commands when in the mount stage. He has to work with 'database datafile' commands *before* he can get what's left of his database open.

> 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
>

Let's assume he does things the way you've suggested (ie, miraculously he gets his database open so that he can issue the 'drop tablespace' command as his first attempt at a solution). Once he's dropped the tablespace, there is absolutely no need to offline drop the datafiles, because they are dropped as part of the tablespace drop.

> You will need to do this for all datafiles for that tablespace.
>

No he won't. Dropping the tablespace drops all the files in one fell swoop.

It would be really nice if people could check their proposed solutions for practicability before posting them here. We're supposed to be offering help, not total confusion and errors.

HJR
> 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 Sat Sep 30 2000 - 19:03:31 CDT