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. SQL query gives "table or view does not exist"

    SQL query gives "table or view does not exist"

    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:
    Why does this query get "table or view does not exist"?

    > s+ abc01
    SQL> SELECT /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */z30_call_no, Z30_BARCODE, Z13_TITLE from ABC01.Z13, Z30, Z103 where ...
    ...
    Error at line 1:
    ORA-00942 : Table or view does not exist

    Resolution:
    This SQL assumes that you are in the abc50 library, but you have done "s+ abc01". You need to do "s+ abc50" instead.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • SQL query against z103 table running very slow
      • SQL Query produces a non-ending Oracle Process
    • 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