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: Stephane Paquette <stephane.paquette_at_standardlife.ca>
Date: Fri, 18 Jul 2003 16:16:47 -0400
Message-Id: <25956.338523@fatcity.com> 





This is a multi-part message in MIME format.



------=_NextPart_000_005D_01C34D47.FCC9B480
Content-Type: text/plain;


        charset="iso-8859-1"


Content-Transfer-Encoding: 7bit



MessageWhy 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



  -----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_000_005D_01C34D47.FCC9B480
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><TITLE>Message</TITLE>


<META http-equiv=3DContent-Type content=3D"text/html; =

charset=3Diso-8859-1">


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

<STYLE></STYLE>

</HEAD>

<BODY bgColor=3D#ffffff>

<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 =

size=3D2>alter=20


database datafile ..... resize 500M;</FONT></SPAN></DIV>


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




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=20

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=20

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=20

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=20

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=20

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_stand=
ardlife.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 =
ORACLE-L</A>=20


    </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 way=20


    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
Received on Fri Jul 18 2003 - 15:16:47 CDT












Original text of this message













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