You can use following select to determine if you have access on the table:
select owner, object_name, object_type from all_objects where object_name='<table_name> or <view_name>'
If you do see the table/view in the previous select, you might need to add the owner in front of the table/view name.
select * from owner.object_name
If you have to add the owner in front of the name, you can consider creating a synonym.
create synonym synonym_name for owner.object_name.
From now on you can just select from the synonym name (which is usually the same name as the table/view name).
If you do not have privileges on the table or view, grant the necessary privileges as the owner of the object:
grant select on object name to privileged user Please refer to http://www.dbmotive.com/oracle_error_codes.php?errcode=00942