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

    Upgrade Express: ORA-00959: tablespace 'TS2X' does not exist

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    We're getting errors in several of the Oracle steps where it is trying to create a new index. The error is:

    /exlibris/aleph/upgrade_express_1801_1901/logs/log/1002.log:ORA-00959: tablespace 'TS2X' does not exist

    The thing is, our tablespace is TS2XA, not TS2X. It appears that somewhere a variable is being set incorrectly to only have the first 4 characters of the tablespace name. Is that possible?

    Can we simply modify the file_list's in ./u20_1/abcnn/scratch directory by changing TS2X references to TS2XA, then re-run the Oracle steps > 999?

    Resolution:
    This message is occurring because the program is reading the $aleph_root file_list.XXX templates to supplement your ABCnn file_list's. This is described in KB 16384-24994.

    The abcnn/scratch/file_list is a *by-product* of the process. The program

    1. reads your ./abcnn/file_list
    2. adds entries from the relevant $aleph_root/tab/file_list.XXXX (which are not included in #1)
    3. writes the merged table out to $alephe_scratch

    It re-does this *each* time. The simplest thing is to add the new indexes, etc., to each of your ./abcnn/file_list's.

    • Article last edited: 10/8/2013