Ahhhhhhhhh, yes! The old database link! Hehe. It can cause problems
between different versions of Oracle.
Database Links 4435282: PL/SQL CANNOT USE DATABASE LINK WITH NAME LONGER
THAN 30 CHARACTERS
Referring to a database link whose name contains more than 30 characters
results in an error. This is incorrect because database link names can
contain up to 128 characters.
Workaround: Reduce the length of the database link name. Or set
GLOBAL_NAMES to FALSE.
Are you ready for some football (Super Bowl)?
Its' Fridayyyyyyyyy! Partyyyyyyyyyy! Hehe.
Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Dr. Eric J. Smith is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Manash Baruah
[mailto:oracledba-ezmlmshield-x90690581.[Email address protected]
Sent: Thursday, January 31, 2008 10:28 AM
To: LazyDBA Discussion
Subject: RE: creating DB Link
Hi,
The version being used is:Oracle9i Enterprise Edition Release 9.2.0.4.0
- 64bit Production
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: Rod Reynolds [mailto:rod.[Email address protected]
Sent: Thursday, January 31, 2008 8:22 PM
To: Manash Baruah
Subject: Re: creating DB Link
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text
What version of Oracle are you using?
Manash Baruah wrote:
> 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.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.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
>
>
>
>
========================================================================
====================================================
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.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.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
Oracle LazyDBA home page