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: Oracle 8i (8.1.7.0.1) + Redhat Linux 7.2 = Cannot create tablespace file > 2 gb

Re: Oracle 8i (8.1.7.0.1) + Redhat Linux 7.2 = Cannot create tablespace file > 2 gb

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 28 Jun 2002 14:58:39 +0100
Message-ID: <3d1c6b90$0$231$ed9e5944@reading.news.pipex.net>


"Joe Salmeri" <JoeSalmeri_at_comcast.net> wrote in message news:BNXS8.424576$Gs.31492095_at_bin5.nnrp.aus1.giganews.com...
> And how is physically backing up 5 2000mb datafiles any different than
> backing up 1 10000mb datafile?
> Either way the same amount of data is backed up.

Its way different if one data file becomes corrupt. Then you have a restore of 2gb not 10. Not to mention that a say 32gb datafile has 7 chances to exactly extend to a 4gb boundary

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
Received on Fri Jun 28 2002 - 08:58:39 CDT

Original text of this message

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