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. NO COLUMNS FOUND FOR TABLE

    NO COLUMNS FOUND FOR TABLE

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    In running p_manage_05, our p_manage_05.c.log has these errors:

    NO COLUMNS FOUND FOR TABLE
    ...
    Error: can't write to file

    And the z11_dmp_ora.log.1 file has:

    SQL*Loader-350: Syntax error at line 8.
    Expecting "," or ")", found "COLUMNS".
    NO COLUMNS FOUND FOR TABLE

    Resolution:
    The odn04/file_list shows that the z11 table is to be created in the TS4D tablespace, but util a/14/1 has no entry for the TS4D tablespace. (This is what happens when the tablespace is full.)

    Oracle was unable to get the initial allocation for this table and produced the above error messages.

    A database file needs to be added to the TS4D tablespace (using util o/13/3).

    Then the job can be rerun (from the beginning) with the same parameters used in the original run.

    Additional Information

    faq, columns, table, tablespace


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • No Circulation Log entry for cir-10 renewal
      • No connection to course reserve records; install_driver(Oracle) failed: ...
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 16.02
      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