troubleshooting Question
Oracle 11g: sqlplus: though tables queried do exist, I get a 'table does not exist' when running query, why?
epifanio67 asked on
Hello Experts,
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?
Regards,
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?
Regards,
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 6 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.