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


-----Original Message-----
From: Kathy Wright
[mailto:oracledba-ezmlmshield-x83832411.[Email address protected]
Sent: Thursday, January 31, 2008 7:53 PM
To: LazyDBA Discussion
Subject: creating DB Link

Use the connect string in the tnsnames.ora file on the db server.

i.e,,
CREATE DATABASE LINK SYNCH_ENVIR_DBLINK
CONNECT TO <USER_NAME>
IDENTIFIED BY <PASSWORD>
USING connect_string;

Kathy

>>> "William R Douglas " <oracledba-ezmlmshield-x27633313.[Email address

>>> protected] 1/31/2008 6:05:51 AM >>>
you missed a ' ('


try this:

CREATE DATABASE LINK SYNCH_ENVIR_DBLINK
CONNECT TO <USER_NAME>
IDENTIFIED BY <PASSWORD>
USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOST_NAME)(PORT = 1521)))
(CONNECT_DATA =(SID = SID_NAME)(SERVER = DEDICATED)) )';








"Manash Baruah " <oracledba-ezmlmshield-x55064903.[Email address
protected]

01/31/2008 06:35 AM

To
"LazyDBA Discussion" <[Email address protected] cc

Subject
Strange error while creating DB Link








Hi All,

While creating a db link with the following script:

CREATE DATABASE LINK SYNCH_ENVIR_DBLINK
CONNECT TO <USER_NAME>
IDENTIFIED BY <PASSWORD>
USING '(DESCRIPTION =
ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOST_NAME)(PORT = 1521)))
(CONNECT_DATA =(SID = SID_NAME)(SERVER = DEDICATED)) )';

I get the following errors:

ORA-00604: error occurred at recursive SQL level 1
ORA-01401: inserted value too large for column
ORA-06512: at line 6

If I reduce the length of the db link name, then it is created. But I
cannot do this as that will result in changes in a huge number of
scripts referring this link name.

If anyone has an explanation for this and the remedy please provide...


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


========================================================================
====================================================


Disclaimer:

This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review the policy at <a
href="http://www.techmahindra.com/Disclaimer.html
">http://www.techmahindra.com/Disclaimer.html</a> externally and <a
href="
http://tim.techmahindra.com/Disclaimer.html
">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
Mahindra.

========================================================================
====================================================


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



============================================================================================================================


Disclaimer:

This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.

============================================================================================================================

Oracle LazyDBA home page