Skip to Main Content
Forums

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!

db link to select only one table

609621Mar 29 2009 — edited Mar 29 2009
Dear all,

I want to create a DB link in my local DB to access only one table in the remote DB .


User a in local DB

User y in remote DB ..Y has got 200 tables..

Can I create a DB link in my local DB as user a and access only one table in remote DB (Y schema)

Is this possible ?


Please let me know If I didn't make this clear ?

Kai
This post has been answered by 153119 on Mar 29 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 26 2009
Added on Mar 29 2009
#general-database-discussions
3 comments
1,019 views