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