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. util o/14/1: "TABLESPACE_WITHOUT_FREE_SPACE" **MASTER RECORD**

    util o/14/1: "TABLESPACE_WITHOUT_FREE_SPACE" **MASTER RECORD**

    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:
    Looking in util o/14/1 we see the message: "TABLESPACE_WITHOUT_FREE_SPACE" for a particular tablespace. How should we handle this?

    Resolution:
    If this tablespace is "autoextend", then Oracle should automatically create a datafile.

    Otherwise, you or your DBA should add a datafile to this tablespace using util o/13/3 or another method ASAP.

    What you do next depends on whether the tablespace name is "TSnD" or "TSnX" (where "TSn" is TS1, TS2, TS3, or TS4).

    A TSnX tablespace has Oracle indexes only in it. The following SQL shows what Oracle indexes are in a tablespace:

    SQL> select index_name from all_indexes where tablespace_name = 'TSnX' order by index_name;

    If you have seen errors in the log or odd behavior in connection with a particular table, then, after space is added to the tablespace, you should do util a/17/3 to rebuild that table's indexes.

    At some point (the following night?) you should do util a/17/3 for all of the indexes found by the above SQL. You could, instead, do util a/17/3 specifying "All". That would take more resources, but will also work.

    A TSnD tablespace has Oracle tables (data) in it. If there have been errors in writing data records, that *should* have been apparent from logs or from messages which users received.
    If the table is an Aleph index table, then you may want/need to run the index job to recreate it. (See KB in regard to what tables are index tables.) KB 8192-2133 describes how to locate and re-index bib records updated since x date; that can make a run of the complete indexing job(s) unnecessary.
    If the table is a "corpus" table, then there is no way to recover the updates which failed due to the lack of space.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • util o/14/1 doesn't have meaningful data; how to tell if AUTOETEND is ON
      • util o/14/8 "ALEPH Tablespaces Total/Free/Used Space Report" is not aligned
    • 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