Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Taking tablespace and datafiles offline

Re: Taking tablespace and datafiles offline

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sun, 18 May 2003 00:33:39 +1000
Message-ID: <Murxa.36057$1s1.524473@newsfeeds.bigpond.com>


"Ed Stevens" <nospam_at_noway.nohow> wrote in message news:b40acvg3gs6esonlfaf34nroggad6dk5dv_at_4ax.com...
> On Fri, 16 May 2003 23:50:06 +1000, "Richard Foote"
> <richard.foote_at_bigpond.com> wrote:
>
> >"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
> >
>
> Hi Richard,
>
> Thanks for the reply -- and for not trashing me! I continue to learn
> . .
>
> I really was asking the OP -- and half expecting to get corrected! <g>
>
> Offhand, I couldn't recall that it was possible to directly offline a
> single file, so thought the question of offlineing TS vs offlineing
> file was like asking "what's the difference between a duck?" and was
> trying to lead the op to that. I did a quick check of the SQL
> reference (tahiti -- Oracle 8.1.7) to make sure I was on solid ground.
> Obviously, my check wasn't thorough enough! I just now retraced my
> steps (browser history still had all the links highlighted) and sure
> enough, there it was and sure enough, I had failed to pick it up! How
> embarrasing!
>
> I'll keep trying and keep learning. If you vets promise not to get
> impatient with me, I'll promise to try to do my homework better and to
> not (unilke some I've seen recently) get into p***ing matches over
> 'experience' or 'credentials.' I'd quickly lose those matches anyway!
> <g>.

Hi Ed,

It all takes time my friend but after a while, you do get the hang of things, especially those things that are most important and those things that you would commonly use.

But (fortunately), the learning never ends....

Hang in there :)

Richard Received on Sat May 17 2003 - 09:33:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US