RE: Increase tablespace, which way is better?

Fri, 18 Jul 2003 13:21:45 -0700

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

Reply via email to