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: Liu, Jack <jliu_at_atla.com>
Date: Fri, 18 Jul 2003 15:28:19 -0500
Message-Id: <25956.338526@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_01C34D6B.20062960
Content-Type: text/plain;

        charset="iso-8859-1"

Two reasons:
1. I don't have enough space in that datafile disk; 2. This way is not as good as alter tablespace.  

Jack

-----Original Message-----
From: Stephane Paquette [mailto:stephane.paquette_at_standardlife.ca] Sent: Friday, July 18, 2003 4: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_01C34D6B.20062960
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 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><SPAN class=3D690392920-18072003><FONT face=3D"Times New Roman"=20
color=3D#0000ff>Two reasons:</FONT></SPAN></DIV>
<DIV><SPAN class=3D690392920-18072003><FONT face=3D"Times New Roman"=20
color=3D#0000ff>1. I don't have enough space in that datafile=20 disk;</FONT></SPAN></DIV>
<DIV><SPAN class=3D690392920-18072003><FONT face=3D"Times New Roman"=20
color=3D#0000ff>2. This way is not as good as alter=20 tablespace.</FONT></SPAN></DIV>
<DIV><SPAN class=3D690392920-18072003><FONT face=3D"Times New Roman"=20
color=3D#0000ff></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D690392920-18072003><FONT face=3D"Times New Roman"=20
color=3D#0000ff>Jack</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 4: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
Received on Fri Jul 18 2003 - 15:28:19 CDT

Original text of this message

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