CREATE DATABASE LINK SYNCH_ENVIR_DBLINK

CONNECT TO chealth1

IDENTIFIED BY siobhan

USING '(DESCRIPTION =

ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = moe )(PORT = 1521)))
(CONNECT_DATA=(SID = r6144113)(SERVER = DEDICATED)) )'

/

Works fine

YOU CAN create a public synonym for the link SYNCH_ENVIR_DBL

Create public synonym SYNCH_ENVIR_DBLINK for SYNCH_ENVIR_DBL;

Kedar Barde

Oracle 9i DBA

Oracle Certified Associate(OCA)



-----Original Message-----
From: Manash Baruah
[mailto:oracledba-ezmlmshield-x73886374.[Email address protected]
Sent: 31 January 2008 14:36
To: LazyDBA Discussion
Subject: RE: creating DB Link



Hi,

It does not work even if I replace the connect string with the one in
the tns entry.

Please note that it works when I make the name of the db link short by 3
letters i.e. if I use SYNCH_ENVIR_DBL instead of SYNCH_ENVIR_DBLINK, it
works fine.

Thanks & Regards,

Manash Partim Baruah

Collaboration Platform LCS-E-commerce| DBA Team| Tech Mahindra Ltd.|

Sharda Center, 6th Floor Annex Building, Pune-4, India

www.techmahindra.com


"Any of the statements or comments made above should be regarded as personal and not necessarily those of Velindre NHS Trust, any constituent part or connected body

Dylai'r datganiadau neu'r sylwadau uchod gael eu trin fel rhai personol ac nid o reidrwydd fel datganiadau neu sylwadau gan Ymddiriedolaeth GIG Felindre, unrhyw ran ohono neu unrhyw gorff sy'n gysylltiedig a'r Ymddiriedolaeth".


Oracle LazyDBA home page