This content has been marked as final. Show 4 replies
Hi,1 person found this helpful
Could you check that synonyms exist or not?
select * from dba_synonyms where synonym_name='synonym_name';
>1 person found this helpful
But for another database select * from ebt_transaction;Its asking to enter schema_name.table_name.
'What' is asking you to enter schema_name.table_name? Oracle doesn't ask things like that.
All Oracle would do is raise an exception that the table or view doesn't exist.
If the user you are connected as does not own the table or view you are querying then you have to include the SCHEMA prefix so Oracle knows what schema you want to query.
select * from abcde ORA-00942: table or view does not exist
The only way to avoid having to include the SCHEMA prefix is to create a public synonym on the table/view or connect as the owner.
You have more than one option to Create access . Grant select on that table , View ,Synonym.1 person found this helpful
Thanks for all your inputs.Really gave me clarity regarding access.