RE: Increase tablespace, which way is better?

[Jamadagni, Rajendra]

Title: Message

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:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]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

********************************************************************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