Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 'Adding new data file' vs 'extending existing data file size' to increase Tablespace

'Adding new data file' vs 'extending existing data file size' to increase Tablespace

From: qazmlp <qazmlp1209_at_rediffmail.com>
Date: 20 Oct 2004 10:30:19 -0700
Message-ID: <db9bbf31.0410200930.2fa3a642@posting.google.com>


As the Tablespace is almost filled on the running system now, we have to add additional space to the Tablespace.

As I understand, the following are the two options available to do that:
1)
Add a new data file to hold the additional data in Tablespace: SQL> alter tablespace my_TS add datafile '/someDir/my_TS2.dbf' size 100M;

2)
Resize the existing Tablespace's data file. SQL> alter database datafile '/someDir/my_TS1.dbf' resize 200M;

What is the best way to go?
In my understanding, the 1st option is not preferable as the Tablespace is spread over 2 data files and hence, performance may get impacted slightly.
Hence, I would prefer to go for the 2nd option.

Kindly give your opinion on it! Received on Wed Oct 20 2004 - 12:30:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US