Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Adding datafile to tablespace in Two-Task set-up

    Adding datafile to tablespace in Two-Task set-up

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Adding data to existing model?
      • Adding different types of units in Aleph -- Master Record
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved