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: Ryan <rgaffuri_at_cox.net>
Date: Fri, 16 May 2003 02:37:44 GMT
Message-ID: <Y9Ywa.14883$823.8441@news1.east.cox.net>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:KaXwa.35169$1s1.509161_at_newsfeeds.bigpond.com...
>
> "Ryan" <rgaffuri_at_cox.net> wrote in message
> news:3dXwa.14795$823.10427_at_news1.east.cox.net...
> > So where is the functionality of being able to take a datafile offline
> while
> > keeping others owned by the tablespace online? Users will still not be
> able
> > to access some data?
> >
>
> Er, I said that right from the beginning!
>
> The functionality is that if you happen to want data in one of the files
> that remain online, you can still get it.
>
> We're having a similar debate in Australia at the moment. Apparently, a
tax
> cut that's only worth $4 a week isn't worth having, and the government
> shouldn't have bothered making it.
>
> Personally, I think it better than a tax hike.
>
> Whaddya want? Blood??
>
> HJR
what kind of system would you use a design where you would take certain datafiles in a tablespace offline?
any rules of thumb in this? Received on Thu May 15 2003 - 21:37:44 CDT

Original text of this message

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