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