Solved

Can views be defined on dblinks

Posted on 2014-04-08
6
235 Views
Last Modified: 2014-06-18
Interview question - Can views be defined on dblinks
0
Comment
Question by:d27m11y
6 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 168 total points
ID: 39986951
YES
CREATE VIEW MyTable_at_Dblink
AS
SELECT * FROM MyTable@dblink;

Open in new window

:p
0
 
LVL 23

Assisted Solution

by:David
David earned 166 total points
ID: 39987005
Usual reminder to include synonyms and object privileges as appropriate.  And of course to pre-create the actual link :)
0
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 166 total points
ID: 39987007
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.
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 40124033
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
 

Author Comment

by:d27m11y
ID: 40142100
Please close this question
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle encryption 12 60
Oracle collections 15 39
pl/sql parameter is null sometimes 2 25
Query - Duplicate dates with different activities counts 10 45
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to take different types of Oracle backups using RMAN.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question