Message-Id: <25962.338573@fatcity.com> From: "Jamadagni, Rajendra" Date: Sat, 19 Jul 2003 11:51:49 -0400 Subject: RE: 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. ------=_NextPartTM-000-5096b6c1-1611-44bf-8d55-6df399c323c7 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C34E0D.AA430F2E" ------_=_NextPart_001_01C34E0D.AA430F2E Content-Type: text/plain; charset="iso-8859-1" We prefer to size them correctly to a max limit and then keep adding files. Because for each raw file, we have a backup file and a tertiary file. This helps in doing backups quickly and in case of crash, we can bring up the database on backup or tertiary data files. We prefer to add files. Raj -----Original Message----- From: Stephane Paquette [mailto:stephane.paquette@standardlife.ca] Sent: Friday, July 18, 2003 5:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: Increase tablespace, which way is better? Why 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_001_01C34E0D.AA430F2E Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message
We=20 prefer to size them correctly to a max limit and then keep adding = files. Because=20 for each raw file, we have a backup file and a tertiary file. This = helps in=20 doing backups quickly and in case of crash, we can bring up the = database on=20 backup or tertiary data files.
 
We=20 prefer to add files.
Raj
-----Original Message-----
From: Stephane Paquette = [mailto:stephane.paquette@standardlife.ca]
Sent: Friday, = July 18,=20 2003 5:15 PM
To: Multiple recipients of list=20 ORACLE-L
Subject: RE: Increase tablespace, which way is=20 better?

Why=20 not just resizing the file ?
alter 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@stan= dardlife.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
Sent: Friday, July 18, = 2003 1:29=20 PM
Subject: Increase = tablespace, which=20 way 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 
 
------_=_NextPart_001_01C34E0D.AA430F2E-- ------=_NextPartTM-000-5096b6c1-1611-44bf-8d55-6df399c323c7 Content-Type: text/plain; name="ESPN_Disclaimer.txt" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="ESPN_Disclaimer.txt" ********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2