$phinx19 wrote:Well it does happen a lot of times that when you check many times, you keep on missing something obvious. Since we can't see your screen, post here the steps that you are running with the output and we shall comment further looking at it.
Yes man these are basic things, no typo error. I have checked everything before making this post.
When i am trying to access DBA views say:
select * from dba_users;I am getting a error saying table or view does not exist even though i am able to describe dba_users and i am also abe to query V$ views.
Need you inputs on this...
Copy the entire session - both commands and responses - and past back here.
# id # whoami # env | grep ORA | sort # sqlplus / as sysdba sql> show user sql> select * from dba_users;
LD_LIBRARY_PATH=/testdata/oracle11g/ORACLE/oraclehome/libKind of odd looking, that Opatch on the path, and that ORACLE_HOME. Did you disguise things for posting?