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

    SQL query gives "table or view does not exist"

    • 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