Can views be defined on dblinks

Interview question - Can views be defined on dblinks
Who is Participating?
MikeOM_DBAConnect With a Mentor Commented:
CREATE VIEW MyTable_at_Dblink
SELECT * FROM MyTable@dblink;

Open in new window

DavidConnect With a Mentor Senior Oracle Database AdministratorCommented:
Usual reminder to include synonyms and object privileges as appropriate.  And of course to pre-create the actual link :)
slightwv (䄆 Netminder)Connect With a Mentor Commented:
The above post shows how to use a link in a view.

You question asked can be taken another way:
Can you use a view in the remote database with a database link?

That too is yes:
select * from some_view@dblink;

As long as the user used for the dblink has select access on the objects.
Steve WalesSenior Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
d27m11yAuthor Commented:
Please close this question
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.