- Article Type: General
- Product: Aleph
- Product Version: 20
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
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