Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to use a Global database link

204773Feb 14 2007 — edited Feb 14 2007
i try to create a global database link through two databases MZFB et MZF14952.
the MZFB database is installed under the machine MZFXPDESK
the MZF14952 database is installed under another machine SUPPORT1

i execute this code
CREATE DATABASE LINK dbl_14952_5
CONNECT TO BELGA_5
IDENTIFIED BY mypwd
USING 'MZFB'

select * from dba_db_links
OWNER DB_LINK USERNAME HOST CREATED
MZF14952 DBL_14952_5.CORP.MYCOMPANY.COM BELGA_5 MZFB 02/14/2007 14:17:21:000

select * from global_name
DBL_14952_1.CORP.MYCOMPANY.COM

select * from all_users@MZFB.CORP.CASTSOFTWARE.COM
=> ORA-02019: connection description for remote database not found
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2007
Added on Feb 14 2007
6 comments
603 views