Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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