Increase tablespace, which way is better?

Fri, 18 Jul 2003 12:36:35 -0700

Title: Message
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 
 

Reply via email to