Re: Taking tablespace and datafiles offline

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 16 May 2003 23:50:06 +1000
Message-ID: <YL5xa.35527$1s1.515100@newsfeeds.bigpond.com>

"Ed Stevens" <nospam_at_noway.nohow> wrote in message news:4td7cv0ukohpnlog86sctkfi4c0l4i11mc_at_4ax.com...
> On Thu, 15 May 2003 07:09:33 GMT, Peter <peter_at_nomorenewsspammin.ca>
> wrote:
>
> >If I take a tablespace offline, are the datafiles inside it also taken
> >offline at the same time?
> >
> >The other way around, if I take all the datafiles of a tablespace
> >offline, is the tablespace technically taken offline?
> >
> >Thanks
> >
>
> What SQL statement do you use to take a datafile offline?

Hi Ed,

I'm not sure if you're asking the OP or asking generally.

alter database datafile 'name' offline;

alter database datafile number offline;

Just in case :)

Richard Received on Fri May 16 2003 - 08:50:06 CDT