RE: 1 tablespace = n datafiles

Nicolas,

There is nothing wrong with tablespaces having more then 1 datafile. It is even necessary when you want to create tablespaces that are larger then 1 disk. There are more reasons to spread your tablespace over more then 1 datafile. In most instances it is done to improve performance.

So you shouldn't worry, but rather read some documentation on this stuff.

Paul

-----Original Message-----
From: VERITE Nicolas BRX/FCR [mailto:nicolas.verite_at_francetelecom.fr] Sent: 11 September 2000 17:03
To: Multiple recipients of list ORACLE-L Subject: 1 tablespace = n datafiles

Hi all !

I got a database that has a tablespace associated with... ...8 datafiles !

Are the performances impacted ?

How can I reduce the number of datafiles to 1 ?

Thanx a lot !
Nico

Nicolas VERITE - DBA Oracle
Univers Informatique - www.universinformatique.fr Fixe: 01 42 21 77 80 - Mobile: 06 62 70 77 48

-- 
Author: VERITE Nicolas BRX/FCR
  INET: nicolas.verite_at_francetelecom.fr

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).