Adding datafile to tablespace in Two-Task set-up
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
We are getting low on tablespace for TS2X. We are two task. Can I use util o/13/1 to add file to tablespace when oracle is on another server?
The original file was 4GB, should I just create a file of the same size (we have enough file space)?
util o/14/1:
TABLESPACE_NAME TOTAL_FREE_SPACE MAX_EXTENT NUM_FREE_EXTENTS
------------------------------ ---------------- ---------- ----------------
LOG 63.9726412 63.9726412 1
SYSAUX 746.785221 739.093496 26
SYSTEM 193.168611 193.043542 2
TS0 631.972153 189.103878 12
TS1 1762.78082 1633.89753 4
TS1D 4750.79719 2717.49276 3
TS1X 4685.6364 2652.45704 3
TS2D 1340.67395 1308.7189 2
TS2X 15.9462595 15.9462595 1
TS3D 1833.81985 1768.97173 3
TS3X 3577.9029 2097.08947 2
TABLESPACE_NAME TOTAL_FREE_SPACE MAX_EXTENT NUM_FREE_EXTENTS
------------------------------ ---------------- ---------- ----------------
TS4D 12598.4831 2305.20379 12
TS4X 3009.34058 2496.3713 3
TSLOB 69.9759389 69.9759389 1
UNDOTBS1 1614.69948 480.201282 67
USERS 200.031756 200.031756 1
Temporary Tablespace Space Usage
TABLESPACE_NAME SIZE M
------------------------------ ----------
TEMP 1007.55347
Sort Segments Usage (in Temporary Tablespace)
TABLESPACE_NAME Total M Used M Free M
------------------------------- ---------- ---------- ----------
TEMP 2064 0 2064
oracle@AlephOrc(aleph0)oradata/aleph0>ls -l *ts*
-rw-r----- 1 oracle dba 4294975488 Apr 9 13:14 aleph0_ts0_01.dbf
-rw-r----- 1 oracle dba 4294975488 Apr 9 13:16 aleph0_ts1_01.dbf
-rw-r----- 1 oracle dba 6291464192 Apr 9 13:12 aleph0_ts1d_01.dbf
-rw-r----- 1 oracle dba 6291464192 Apr 9 13:12 aleph0_ts1x_01.dbf
-rw-r----- 1 oracle dba 4194312192 Apr 9 13:16 aleph0_ts2d_01.dbf
-rw-r----- 1 oracle dba 4194312192 Apr 9 13:15 aleph0_ts2x_01.dbf
-rw-r----- 1 oracle dba 8388616192 Apr 9 13:13 aleph0_ts3d_01.dbf
-rw-r----- 1 oracle dba 14680072192 Apr 9 13:16 aleph0_ts3x_01.dbf
-rw-r----- 1 oracle dba 10737426432 Apr 9 13:12 aleph0_ts4d_01.dbf
-rw-r----- 1 oracle dba 10737426432 Apr 9 13:12 aleph0_ts4d_02.dbf
-rw-r----- 1 oracle dba 10737426432 Apr 9 13:12 aleph0_ts4d_03.dbf
-rw-r----- 1 oracle dba 10485768192 Apr 9 13:12 aleph0_ts4d_04.dbf
-rw-r----- 1 oracle dba 2097160192 Apr 9 13:06 aleph0_ts4d_05.dbf
-rw-r----- 1 oracle dba 17179877376 Apr 9 13:12 aleph0_ts4x_01.dbf
-rw-r----- 1 oracle dba 73408512 Apr 9 00:22 aleph0_tslob01.dbf
Resolution:
Though util o/14/1 displays the tablespaces correctly in a Two-Task set-up, util o/13 can't be used to add a file to a tablespace in this arrangement.
The site did the following to add a 2-gig datafile to the TS2X tablespace on their database server:
sqlplus /nolog
connect ALEPH_DBA/ALEPH_DBA as sysdba
set pause off
ALTER TABLESPACE TS2X ADD DATAFILE '/exlibris/oradata/aleph0/aleph0_ts2x_02.dbf' SIZE 2000M;
Note: if your site has a DBA, that person should handle the addition of datafiles to tablespaces.
- Article last edited: 10/8/2013