Skip Headers

Oracle® Database SQL Reference
10g Release 1 (10.1)

Part Number B10759-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

Distributed Queries

The Oracle distributed database management system architecture lets you access data in remote databases using Oracle Net and an Oracle Database server. You can identify a remote table, view, or materialized view by appending @dblink to the end of its name. The dblink must be a complete or partial name for a database link to the database containing the remote table, view, or materialized view.


See Also:



Restrictions on Distributed Queries

Distributed queries are currently subject to the restriction that all tables locked by a FOR UPDATE clause and all tables with LONG columns selected by the query must be located on the same database. For example, the following statement raises an error because it selects press_release, a LONG value, from the print_media table on the remote database and locks the print_media table on the local database:

SELECT r.product_id, l.ad_id, r.press_release 
   FROM pm.print_media@remote r, pm.print_media l
   FOR UPDATE OF l.ad_id;

In addition, Oracle Database currently does not support distributed queries that select user-defined types or object REFs on remote tables.