Message-Id: <25956.338523@fatcity.com> From: "Stephane Paquette" Date: Fri, 18 Jul 2003 16:16:47 -0400 Subject: RE: Increase tablespace, which way is better? This is a multi-part message in MIME format. ------=_NextPart_000_005D_01C34D47.FCC9B480 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit MessageWhy 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@standardlife.ca -----Original Message----- From: ml-errors@fatcity.com [mailto:ml-errors@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 ----- Original Message ----- From: Liu, Jack To: Multiple recipients of list ORACLE-L Sent: Friday, July 18, 2003 1:29 PM Subject: Increase tablespace, which way is better? 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_000_005D_01C34D47.FCC9B480 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message
Why=20 not just resizing the file ?
alter=20 database datafile ..... resize 500M;
 

Stephane=20 Paquette

Administrateur=20 de bases de donnees

Database=20 Administrator

Standard=20 Life

www.standardlife.ca

Tel.=20 (514) 499-7999 7470 and (514) 925-7187

stephane.paquette@stand= ardlife.ca

-----Original Message-----
From: = ml-errors@fatcity.com=20 [mailto:ml-errors@fatcity.com]On Behalf Of AK
Sent: = Friday,=20 July 18, 2003 4:59 PM
To: Multiple recipients of list=20 ORACLE-L
Subject: Re: Increase tablespace, which way is=20 better?

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=20 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=20 add datafile '/u01/oradata/orcl/users02.dbf' size 100m;
 
Thanks,
 
Jack