Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Increase tablespace, which way is better?

RE: Increase tablespace, which way is better?

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Sat, 19 Jul 2003 11:51:49 -0400
Message-Id: <25962.338573@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.



------=_NextPartTM-000-5096b6c1-1611-44bf-8d55-6df399c323c7
Content-Type: multipart/alternative;


        boundary="----_=_NextPart_001_01C34E0D.AA430F2E"



------_=_NextPart_001_01C34E0D.AA430F2E


Content-Type: text/plain;


        charset="iso-8859-1"



We prefer to size them correctly to a max limit and then keep adding files.
Because for each raw file, we have a backup file and a tertiary file. This
helps in doing backups quickly and in case of crash, we can bring up the
database on backup or tertiary data files.
 


We prefer to add files.


Raj



-----Original Message-----


From: Stephane Paquette [mailto:stephane.paquette_at_standardlife.ca]
Sent: Friday, July 18, 2003 5:15 PM


To: Multiple recipients of list ORACLE-L
Subject: RE: Increase tablespace, which way is better?




Why not just resizing the file ?


alter database datafile ..... resize 500M;
 




Stephane Paquette




Administrateur de bases de donnees



Database Administrator



Standard Life



www.standardlife.ca



Tel. (514) 499-7999 7470 and (514) 925-7187



stephane.paquette_at_standardlife.ca <mailto:stephane.paquette_at_standardlife.ca>




-----Original Message-----


From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf Of AK
Sent: Friday, July 18, 2003 4:59 PM


To: Multiple recipients of list ORACLE-L
Subject: Re: Increase tablespace, which way is better?




what are u gaining in #1 . 
 


-ak






Hi, 


I want to increase tablespace, just want to know which way is better:
1. ALTER TABLESPACE SYSTEM



ADD DATAFILE '/u01/oradata/orcl/users02.dbf'
SIZE 1M



AUTOEXTEND ON



NEXT 1M



MAXSIZE 100M;

 
2.alter tablespace system add datafile '/u01/oradata/orcl/users02.dbf' size
100m;
 


Thanks,
 


Jack 
 




------_=_NextPart_001_01C34E0D.AA430F2E


Content-Type: text/html;


        charset="iso-8859-1"


Content-Transfer-Encoding: quoted-printable



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

<HTML xmlns:o =3D=20



"urn:schemas-microsoft-com:office:office"><HEAD>


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

charset=3Diso-8859-1">


<TITLE>Message</TITLE>




<META content=3D"MSHTML 5.50.4926.2500" name=3DGENERATOR>

<STYLE></STYLE>

</HEAD>

<BODY bgColor=3D#ffffff>

<DIV><SPAN class=3D506235015-19072003><FONT face=3DArial =

color=3D#0000ff size=3D2>We=20


prefer to size them correctly to a max limit and then keep adding =
files. Because=20


for each raw file, we have a backup file and a tertiary file. This =
helps in=20


doing backups quickly and in case of crash, we can bring up the =
database on=20


backup or tertiary data files.</FONT></SPAN></DIV>


<DIV><SPAN class=3D506235015-19072003><FONT face=3DArial =

color=3D#0000ff=20


size=3D2></FONT></SPAN>&nbsp;</DIV>


<DIV><SPAN class=3D506235015-19072003><FONT face=3DArial =

color=3D#0000ff size=3D2>We=20


prefer to add files.</FONT></SPAN></DIV>


<DIV><SPAN class=3D506235015-19072003><FONT face=3DArial =

color=3D#0000ff=20


size=3D2>Raj</FONT></SPAN></DIV>


<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">

  <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20


  size=3D2>-----Original Message-----<BR><B>From:</B> Stephane Paquette =



  [mailto:stephane.paquette_at_standardlife.ca]<BR><B>Sent:</B> Friday, =
July 18,=20


  2003 5:15 PM<BR><B>To:</B> Multiple recipients of list=20
  ORACLE-L<BR><B>Subject:</B> RE: Increase tablespace, which way is=20
  better?<BR><BR></FONT></DIV>


  <DIV><SPAN class=3D626421520-18072003><FONT face=3DArial =
color=3D#0000ff size=3D2>Why=20


  not just resizing the file ?</FONT></SPAN></DIV>
  <DIV><SPAN class=3D626421520-18072003><FONT face=3DArial =
color=3D#0000ff=20


  size=3D2>alter database datafile ..... resize =
500M;</FONT></SPAN></DIV>


  <DIV><SPAN class=3D626421520-18072003><FONT face=3DArial =
color=3D#0000ff=20


  size=3D2></FONT></SPAN>&nbsp;</DIV>


  <DIV><SPAN class=3D626421520-18072003><FONT face=3DArial =
color=3D#0000ff size=3D2>

  <DIV>
  <DIV>
  <H2 style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DFR-CA=20


  style=3D"FONT-SIZE: 12pt"><EM><FONT face=3DArial>Stephane=20
  Paquette<o:p></o:p></FONT></EM></SPAN></H2>
  <P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DFR-CA =



  style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: =
12.0pt; mso-ansi-language: FR-CA">Administrateur=20
  de bases de donnees</SPAN></P>


  <P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DFR-CA =



  style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: =
12.0pt; mso-ansi-language: FR-CA">Database=20
  Administrator</SPAN></P>


  <P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN=20
  style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: =
12.0pt">Standard=20


  Life<o:p></o:p></SPAN></P>


  <P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DFR-CA =



  style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: =
12.0pt; mso-ansi-language: FR-CA">www.standardlife.ca</SPAN><SPAN=20
  style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: =
12.0pt"><o:p></o:p></SPAN></P>


  <P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DFR-CA =



  style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: =
12.0pt; mso-ansi-language: FR-CA">Tel.=20
  (514) 499-7999 7470 and (514) 925-7187</SPAN></P>
  <P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DFR-CA =



  style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: =
12.0pt; mso-ansi-language: FR-CA"></SPAN><SPAN=20
  lang=3DFR-CA=20


  style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: =
12.0pt; mso-ansi-language: FR-CA; mso-fareast-font-family: 'Times New =
Roman'; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><A=20
  =


href=3D"mailto:stephane.paquette_at_standardlife.ca">stephane.paquette_at_stan=
dardlife.ca</A></SPAN></P></DIV></DIV></FONT></SPAN></DIV>
  <BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
    <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20


    size=3D2>-----Original Message-----<BR><B>From:</B> =
ml-errors_at_fatcity.com=20


    [mailto:ml-errors_at_fatcity.com]<B>On Behalf Of =


</B>AK<BR><B>Sent:</B> Friday,=20



    July 18, 2003 4:59 PM<BR><B>To:</B> Multiple recipients of list=20
    ORACLE-L<BR><B>Subject:</B> Re: Increase tablespace, which way is=20
    better?<BR><BR></FONT></DIV>


    <DIV><FONT face=3DArial size=3D2>what are u gaining in #1 . =


</FONT></DIV>


    <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
    <DIV><FONT face=3DArial size=3D2>-ak</FONT></DIV>
    <BLOCKQUOTE dir=3Dltr=20




    style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">


      <DIV style=3D"FONT: 10pt arial">----- Original Message ----- =


</DIV>


      <DIV=20
      style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
      <A title=3Djliu_at_atla.com href=3D"mailto:jliu_at_atla.com">Liu, =
Jack</A> </DIV>
      <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3DORACLE-L_at_fatcity.com=20
      href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list=20
      ORACLE-L</A> </DIV>
      <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, July 18, =
2003 1:29=20
      PM</DIV>
      <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Increase =
tablespace, which=20
      way is better?</DIV>
      <DIV><BR></DIV>
      <DIV><FONT face=3D"Times New Roman" color=3D#0000ff>Hi, <BR>I =
want to increase=20
      tablespace, just want to know which way is better:<BR>1. ALTER =
TABLESPACE=20
      SYSTEM<BR>ADD DATAFILE '/u01/oradata/orcl/users02.dbf'<BR>SIZE=20
      1M<BR>AUTOEXTEND ON<BR>NEXT 1M<BR>MAXSIZE 100M;</FONT></DIV>
      <DIV>&nbsp;</DIV>
      <DIV><FONT face=3D"Times New Roman" color=3D#0000ff>2.alter =
tablespace system=20
      add datafile '/u01/oradata/orcl/users02.dbf' size =
100m;</FONT></DIV>
      <DIV>&nbsp;</DIV>
      <DIV><FONT face=3D"Times New Roman" =
color=3D#0000ff>Thanks,</FONT></DIV>
      <DIV>&nbsp;</DIV>
      <DIV><FONT face=3D"Times New Roman"><FONT =
color=3D#0000ff>Jack<SPAN=20
      class=3D380473019-18072003>&nbsp;</SPAN></FONT></FONT></DIV>
      <DIV><FONT face=3D"Times New Roman"><FONT color=3D#0000ff><SPAN=20
      =




class=3D380473019-18072003></SPAN></FONT></FONT>&nbsp;</DIV></BLOCKQUOTE=
></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>



------_=_NextPart_001_01C34E0D.AA430F2E--




------=_NextPartTM-000-5096b6c1-1611-44bf-8d55-6df399c323c7
Content-Type: text/plain;


        name="ESPN_Disclaimer.txt"


Content-Transfer-Encoding: 7bit


Content-Disposition: attachment;


        filename="ESPN_Disclaimer.txt"


********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2


Received on Sat Jul 19 2003 - 10:51:49 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US