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

You've rather missed the point, haven't you.

If you have 5 2Gb files, you can back 1 of them up on Monday, one on Tuesday, one on Wednesday, one on Thursday and one on Friday.

Of 2 of them on Monday, have an evening off on Tuesday, two on Wednesday, watch the Kumars on Thursday night, and finish the cycle off on Friday.

Or 4 of them on Monday. Have the rest of the week in Marbella. Finish the job on Friday.

If you have 1 10Gb file, er, you have to back it all up on Monday.

So yes, same amount of data. But infinitely more options with multiple files than with just one.

HJR "Joe Salmeri" <JoeSalmeri_at_comcast.net> wrote in message news:BNXS8.424576$Gs.31492095_at_bin5.nnrp.aus1.giganews.com...
> > > For the same reasons that you don't want to carve your 100 GB hard
drive
> > up
> > > into 50 2 GB partitions.
> > >
> >
> > Not comparable situations at all.
>
> In your mind.
>
> >Unless you are using export, which doesn't count as a physical backup,
then
> the
> > smallest unit of backup and restore in an Oracle database, until you get
> to 9i, is
> > that data file. Big data files, big backups. Small data files, small
> backups
> > extended over a longer backup cycle.
>
> 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.
>
>
>
>
Received on Fri Jun 28 2002 - 14:56:57 CDT