Message-Id: <25956.338509@fatcity.com> From: "Liu, Jack" Date: Fri, 18 Jul 2003 14:28:54 -0500 Subject: 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_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" Message
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