Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Synonym of a table gives no data

BmFeb 26 2013 — edited Mar 26 2013
Hi,

I am working on a table PO.PO_REQUISITION_LINES_ALL which contains enough data.

I have 2 synonyms "*PO_REQUISITION_LINES*" and "*PO_REQUISITION_LINES_ALL*" for PO.PO_REQUISITION_LINES_ALL table.

When run query "*select* * *from PO_REQUISITION_LINES_ALL*" it gives me data.
But when I run "*select* * *from PO_REQUISITION_LINES*" it gives no data.

I am not able to understand if both synonyms are created on the same table then why I dont get the same result.

Please help.

Bm
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2013
Added on Feb 26 2013
26 comments
1,772 views