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