Increase tablespace, which way is better?

From: Liu, Jack <jliu_at_atla.com>
Date: Fri, 18 Jul 2003 14:28:54 -0500
Message-Id: <25956.338509@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_01C34D62.D38C0AD0
Content-Type: text/plain;

charset="iso-8859-1"

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_01C34D62.D38C0AD0
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o =

"urn:schemas-microsoft-com:office:office"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>

<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face="Times New Roman" color=#0000ff>Hi, <BR>I want to increase
tablespace, just want to know which way is better:<BR>1. ALTER TABLESPACE SYSTEM<BR>ADD DATAFILE '/u01/oradata/orcl/users02.dbf'<BR>SIZE 1M<BR>AUTOEXTEND ON<BR>NEXT 1M<BR>MAXSIZE 100M;</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#0000ff>2.alter tablespace system add
datafile '/u01/oradata/orcl/users02.dbf' size 100m;</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#0000ff>Thanks,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman"><FONT color=#0000ff>Jack<SPAN
class=380473019-18072003> </SPAN></FONT></FONT></DIV>
<DIV><FONT face="Times New Roman"><FONT color=#0000ff><SPAN
class=380473019-18072003> </SPAN></FONT></FONT></DIV></BODY></HTML> Received on Fri Jul 18 2003 - 14:28:54 CDT