Re: Increase tablespace, which way is better?

[AK]

Title: Message

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