Re: One datafile vs Several

From: christophe jacques <christophe.jacques_at_ceram.fr>
Date: 1998/05/12
Message-ID: <35587BDA.E823545C@ceram.fr>#1/1

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
Received on Tue May 12 1998 - 00:00:00 CDT