Xref: alice comp.databases.oracle.server:28671 Path: alice!news-feed.fnsi.net!news.idt.net!newshub.northeast.verio.net!btnet-peer!btnet-feed1!btnet!news-reader.bt.net!not-for-mail From: "Michael P James" Newsgroups: comp.databases.oracle.server References: <6smm42$6cm$1@arachne.labyrinth.net.au> <35EE66C7.CBDF17B3@datenrevision.de> Subject: Re: Select a from remote table Lines: 35 X-Newsreader: Microsoft Outlook Express 4.72.2106.4 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Message-ID: Date: Wed, 09 Sep 1998 19:13:15 GMT NNTP-Posting-Date: Wed, 09 Sep 1998 20:13:15 BST In oder to link to a remote database your firstly need to create the database link. I think you have conquered this but then to conect to a table on a remote database you would use the following : select * from user_table@remote_domain - This will give you the data from the remote table user_tables select * from user_tables - This will then give you the data from the currect database. Rolf Hauck wrote in message <35EE66C7.CBDF17B3@datenrevision.de>... >My Oracle Documentation (for ORA 7.x) states that the name of the dblink >must match the name of the remote database. Are you sure about this? > >Rolf > >Hong Yew wrote: >> >> We are using Personal Oracle to access a remote Oracle 8 NT server .We can't >> seems to select from a remote table using : >> >> SELECT * FROM username.table@remote_dblink; >> >> We have created a database link of with >> >> CREATE DATABASE LINK remote_dblink CONNECT TO username >> IDENTIFIED BY password VALUE 'remote_domain' >> >> We are able to CONNECT to the remote site using >> username/password@remote_domain! >>