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

    ORA-00959: tablespace 'TS2X' does not exist

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

    Description:
    I ran p-manage-07 as a test, and see these Oracle errors in the log:

    >> DROP TABLE ABC01.Z13U
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist
    ...
    ...

    >> TABLESPACE TS2X
    *
    ERROR at line 5:
    ORA-00959: tablespace 'TS2X' does not exist

    The job appears to have run correctly, but I'm curious what is causing the errors?

    Resolution:
    The error messages occurred because of the references to the z13u and ts2X the $aleph_root/tab/file_list.BIB file_list template. (The template is used when the abc01 prof_library has the line: file_list_type=BIB.
    If a table is not in the $data_root/file_list but is in file_list.BIB, the program uses the latter.)

    If you want to have a z13u table, you have two choices:
    1. Add z13u to your abc01 file list
    2. Add the following line to the abc01 prof_library:
    setenv file_list_ts2 xxxxx <where xxxxx is the tablespace you want used when the file_list template has "TS2D">

    This is described in detail in KB's 8192-3719 and 8037.

    If you *don't* want to have a z13u table, then you can, as described in KB 8192-5095, insert
    NA z13u
    NA z13u_id
    lines in your abc01 file_list.

    • Article last edited: 10/8/2013