asked on
Oracle 11g: sqlplus: though tables queried do exist, I get a 'table does not exist' when running query, why?
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,
Oracle DatabaseSQL
Last Comment
awking00
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Isn't that kind of what I said?
Look at the timestamps of the replies. Less than 2 minutes between them.
I was typing mine while you were typing yours and you finished first. When I started typing my answer there was no other reply there.
I was typing mine while you were typing yours and you finished first. When I started typing my answer there was no other reply there.
ASKER
thank you experts... I really appreciate your help
And usually I'm the slow typist :-) No harm meant.