Re: Help needed with database links

create database link mylinkname -
connect to schemaname identified by schemapassword - using 'tnsnamesdbname'

where tnsnamesdbname is the name of the database as is included in your tnsnames.ora file

you can then try it out with
select * from v$database_at_mylinkname;

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!