Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: take 1 datafile offline ?
You can take the one datafile offline. Anything accessed by users that is
available from the remaining online datafiles will work fine. Anything they
want that's stored within the offlined file will generate the 'file X is
unable to be read at this time' error.
Regards
HJR
"robert" <newsreply@#removethis#cookiesoftware.nl> wrote in message
news:ar8r9p$k20$1_at_reader15.wxs.nl...
> Hi there,
>
> I have a question about datafiles / tablespaces.
> Lets say i have a tablespace called 'APPDATA' which has 4 datafiles
> "FILE1.ora,FILE2...etc".
>
> FILE1 is on a HDD who i don't trust any more. Can i just take that one
> datafile offline, copy to an other disk and take it online again ? Or do i
> have to take the entire tablespace offline ?
> I have done that before (alter tablespace blablabla) and then used a
rename
> datfile.....
> But i thought i would be nice to do this on the fly.
>
>
> cheers,
>
> Robert
>
>
Received on Sun Nov 17 2002 - 13:44:55 CST