Oracle 11g: sqlplus: though tables queried do exist, I get a 'table does not exist' when running query, why?
Posted on 2013-01-04
Oracle 11g: via sqlplus: connected to db successfully.
I run: SELECT table_name FROM all_tables;
I get all tables available....
However, when I try to simple query such:
SELECT * FROM tableName;
I get: table does not exist
is this a permission issue?
Is there a way via the command line to know what permissions I have?