| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Increase tablespace, which way is better?
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> </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> </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=20style=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> </DIV>
<DIV><FONT face=3DArial size=3D2>-ak</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
<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> </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> </DIV>
<DIV><FONT face=3D"Times New Roman" =
color=3D#0000ff>Thanks,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"Times New Roman"><FONT =
color=3D#0000ff>Jack<SPAN=20
class=3D380473019-18072003> </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
 |
 |