Message-Id: <25956.338519@fatcity.com> From: "AK" Date: Fri, 18 Jul 2003 13:00:27 -0700 Subject: Re: Increase tablespace, which way is better? 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: 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=20 ------=_NextPart_000_045D_01C34D2C.8F5A37A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message
what are u gaining in #1 . =
 
-ak
----- Original Message -----
From:=20 Liu, Jack =
To: Multiple recipients of list = ORACLE-L=20
Sent: Friday, July 18, 2003 = 1:29 PM
Subject: Increase tablespace, = which way=20 is better?

Hi,
I want to = increase=20 tablespace, just want to know which way is better:
1. ALTER = TABLESPACE=20 SYSTEM
ADD DATAFILE '/u01/oradata/orcl/users02.dbf'
SIZE=20 1M
AUTOEXTEND ON
NEXT 1M
MAXSIZE 100M;
 
2.alter tablespace = system add=20 datafile '/u01/oradata/orcl/users02.dbf' size 100m;
 
Thanks,
 
Jack 
 
=