This is a multi-part message in MIME format.
------=_NextPart_000_045D_01C34D2C.8F5A37A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Messagewhat are u gaining in #1 .=20
-ak
- Original Message -----=20
From: Liu, Jack=20
To: Multiple recipients of list ORACLE-L=20
Sent: Friday, July 18, 2003 1:29 PM
Subject: Increase tablespace, which way is better?
Hi,=20
I want to increase tablespace, just want to know which way is better:
- 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=20
------=_NextPart_000_045D_01C34D2C.8F5A37A0
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.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<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
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 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> </DIV>
<DIV><FONT face=3D"Times New Roman" color=3D#0000ff>2.alter tablespace =
system add=20
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
=
class=3D380473019-18072003></SPAN></FONT></FONT> </DIV></BLOCKQUOTE>=
Received on Fri Jul 18 2003 - 15:00:27 CDT