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




Oracle LazyDBA home page