Skip to Main Content

Oracle Database Discussions

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!

view query containing a specific table or synonym

Nel MarcusMay 5 2010 — edited May 5 2010
Hi all,

I need to scan all the views in a database which are using a specific table or synonym in the query used to pull the data. certainly I cannot go to each view and check the script as it would it take more time. please suggest any solution here.

Thanks.
This post has been answered by sb92075 on May 5 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2010
Added on May 5 2010
2 comments
506 views