Re: Taking tablespace and datafiles offline

From: Ryan <rgaffuri_at_cox.net>
Date: Thu, 15 May 2003 22:22:47 GMT
Message-ID: <XqUwa.13356$823.4397@news1.east.cox.net>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:IuLwa.34838$1s1.506252_at_newsfeeds.bigpond.com...
>
> "Peter" <peter_at_nomorenewsspammin.ca> wrote in message
> news:06f6cv4mdhv9vug5o13gjf5t945dkf1qrn_at_4ax.com...
> > If I take a tablespace offline, are the datafiles inside it also taken
> > offline at the same time?
>
> Yes. All the datafiles are offlined when the tablespace is offlined.
>
> >
> > The other way around, if I take all the datafiles of a tablespace
> > offline, is the tablespace technically taken offline?
>
> Absolutely not! This is one of the reasons multi-file tablespaces are a
> better management option than their single-monolithic-equivalent-in-size
> cousins. You can offline a single datafile, and the rest of the tablespace
> remains open for business (selects and DML). If the bit of data you want
to
> access happens to be stored on the offlined datafile, then tough.... but
> otherwise, it would be business as usual, and no inconvenience to your
> users.
>
> Regards
> HJR
>
>
>

How do you manage which objects go in which datafile? So if you take a datafile offline how do you know which objects you took offline?

> >
> > Thanks
> >
> >
>
>
Received on Thu May 15 2003 - 17:22:47 CDT