RE: 1 tablespace = n datafiles

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Mon, 11 Sep 2000 13:06:45 -0400
Message-Id: <10616.116647@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C01C12.AA1F57C6
Content-Type: text/plain;

charset="iso-8859-1"

Nico, there's nothing wrong with 8 datafiles in a tablespace unless they are small and adding to fragmentation.
If you want to reduce the # of datafiles, you need to recreate the tablespace (export, drop tablespace, recreate the way you want it, import)

HTH
Lisa
Ft. Lauderdale, FL,USA

-----Original Message-----
From: VERITE Nicolas BRX/FCR [mailto:nicolas.verite_at_francetelecom.fr] Sent: Monday, September 11, 2000 11:03 AM 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).

------_=_NextPart_001_01C01C12.AA1F57C6
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">

<HTML>

<HEAD>

<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">


<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =

5.5.2650.12">


<TITLE>RE: 1 tablespace =3D n datafiles</TITLE>

</HEAD>

<BODY>




<P><FONT SIZE=3D2>Nico, there's nothing wrong with 8 datafiles in a =

tablespace unless they are small and adding to fragmentation.</FONT>


<BR><FONT SIZE=3D2>If you want to reduce the # of datafiles, you need =

to recreate the tablespace (export, drop tablespace, recreate the way =
you want it, import)</FONT></P>



<P><FONT SIZE=3D2>HTH</FONT>

<BR><FONT SIZE=3D2>Lisa</FONT>

<BR><FONT SIZE=3D2>Ft. Lauderdale, FL,USA</FONT>

</P>




<P><FONT SIZE=3D2>-----Original Message-----</FONT>

<BR><FONT SIZE=3D2>From: VERITE Nicolas BRX/FCR [<A =

HREF=3D"mailto:nicolas.verite_at_francetelecom.fr">mailto:nicolas.verite_at_fr=
ancetelecom.fr</A>]</FONT>


<BR><FONT SIZE=3D2>Sent: Monday, September 11, 2000 11:03 AM</FONT>

<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>

<BR><FONT SIZE=3D2>Subject: 1 tablespace =3D n datafiles</FONT>

</P>

<BR>




<P><FONT SIZE=3D2>Hi all !</FONT>

</P>




<P><FONT SIZE=3D2>I got a database that has a tablespace associated =

with...</FONT>


<BR><FONT SIZE=3D2>...8 datafiles !</FONT>

</P>




<P><FONT SIZE=3D2>Are the performances impacted ?</FONT>

</P>




<P><FONT SIZE=3D2>How can I reduce the number of datafiles to 1 =

?</FONT>


</P>




<P><FONT SIZE=3D2>Thanx a lot !</FONT>

<BR><FONT SIZE=3D2>Nico</FONT>

</P>




<P><FONT SIZE=3D2>Nicolas VERITE - DBA Oracle</FONT>

<BR><FONT SIZE=3D2>Univers Informatique - =

www.universinformatique.fr</FONT>


<BR><FONT SIZE=3D2>Fixe: 01 42 21 77 80 - Mobile: 06 62 70 77 48</FONT>

</P>




<P><FONT SIZE=3D2>-- </FONT>

<BR><FONT SIZE=3D2>Author: VERITE Nicolas BRX/FCR</FONT>

<BR><FONT SIZE=3D2>&nbsp; INET: nicolas.verite_at_francetelecom.fr</FONT>

</P>




<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =

538-5051&nbsp; FAX: (858) 538-5051</FONT>


<BR><FONT SIZE=3D2>San Diego, =

California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access / Mailing Lists</FONT>


<BR><FONT =

SIZE=3D2>---------------------------------------------------------------=
-----</FONT>


<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =

E-Mail message</FONT>


<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =

'ListGuru') and in</FONT>


<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =

ORACLE-L</FONT>


<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =

from).&nbsp; You may</FONT>


<BR><FONT SIZE=3D2>also send the HELP command for other information =

Received on Mon Sep 11 2000 - 12:06:45 CDT