Re: One datafile vs Several

From: <cmohan_at_iname.com>
Date: 1998/05/12
Message-ID: <6jajma$cl0$1@nnrp1.dejanews.com>#1/1

With multiple datafiles for a tablespace : If you are running in archivelog mode, when you have a datablock corruption, you can restore the backed up datafile and apply the redo logs. The recovery will be much faster!

In article <35587BDA.E823545C_at_ceram.fr>, christophe jacques <christophe.jacques_at_ceram.fr> wrote:
>
> Hello,
>
> It could be useful to use several datafiles on several disks to increase
>
> I/O speed.
>
> Brian Schanblatt wrote:
>
> > hello!
> > we:
> > ORACLE 7.3.3.4
> > AIX 4.1.2
> >
> > We have a 1GB tablespace spread out over 5 datafiles.
> > I would like to export everything,
> > drop the tablespace, recreate it with 1 large datafile
> > and re-import.
> >
> > Is this worthwhile? Are there advantages to having one datafile
> > for a tablespace instead of several?
> > All suggestions welcome!
> > brigo_at_idt.net
> > bshan_at_ymail.yu.edu
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 12 1998 - 00:00:00 CDT