RE: Increase tablespace, which way is better?

[Liu, Jack]

Title: Message

Two reasons: 1. I don't have enough space in that datafile disk; 2. This way is not as good as alter tablespace.   Jack -----Original Message----- From: Stephane Paquette [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 4: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