RE: db-links question
Alex, Yes, the connection remains open unless it is explicitly closed (see Note: 1034343.6). The session also takes out a lock on the local RBS (see Note:74811.1) as this could be part of a distributed transaction. If this is a long running query this can lead to abnormal growth in the RBS since the active transaction in the RBS will prevent the RBS from wrapping into that extent. You can avoid this by issuing SET TRANSACTION READ ONLY; prior to running the distributed query. AFAIK, you can use MTS connections, although I would recommend using dedicated connections for any links used for replication (push and refresh operations). HTH, -- Anita --- Hillman, Alex [EMAIL PROTECTED] wrote: So you mean that connection to the remote DB stays open until session ends which issued query on remote DB. Are these connection dedicated? I think yes bur did not check. Is it possible to use MTS for such connection? And all new features like connection pooling etc. Alex Hillman -Original Message- Sent: Monday, July 09, 2001 6:55 PM To: Multiple recipients of list ORACLE-L Yes, it creates a session. If you want to do a(n) SQL trace, you can do a SELECT 'x' FROM dual@remote_site, find the session at the remote site and turn on the trace, then run your next query. Henry -Original Message- Sent: Monday, July 09, 2001 5:06 PM To: Multiple recipients of list ORACLE-L If I query table in the remote database using database link does user in the remote database which is referenced in the database link create session in the remote database and if not could somebody explain how remote query is executed. Alex Hillman P.S. I know that I could try it myself but I am layzy (sp?) and tired (fighting with Ross for access to printing presses :-) ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: db-links question
Yes, it creates a session. If you want to do a(n) SQL trace, you can do a SELECT 'x' FROM dual@remote_site, find the session at the remote site and turn on the trace, then run your next query. Henry -Original Message- Sent: Monday, July 09, 2001 5:06 PM To: Multiple recipients of list ORACLE-L If I query table in the remote database using database link does user in the remote database which is referenced in the database link create session in the remote database and if not could somebody explain how remote query is executed. Alex Hillman P.S. I know that I could try it myself but I am layzy (sp?) and tired (fighting with Ross for access to printing presses :-) ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: db-links question
Hillman, Alex wrote: If I query table in the remote database using database link does user in the remote database which is referenced in the database link create session in the remote database and if not could somebody explain how remote query is executed. Alex Hillman P.S. I know that I could try it myself but I am layzy (sp?) and tired (fighting with Ross for access to printing presses :-) ) Ir does. A DB link is nothing else than a named connection. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: db links...
Hi, Create {public} database link LINK connect to remote_db_username identified by remote_db_username_password using 'connect_string_as_found_in_tnsnames_on_machine_where_you_create_database_link'; There may be some issues with global name settings that may force you to name the database link exactly the same as the global name of the remote database. jack Saurabh Sharma To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ssharma1@fcsl cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) td.com Subject: db links... Sent by: [EMAIL PROTECTED] om 05-07-2001 09:05 Please respond to ORACLE-L hi all, can any body has idea of how to create db links. we have 4-5 servers some are test and some producn. while requiring some info from other DBs how do i refer them ythrough DBlinks. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: db links...
Hi saurabh, There are two types of database links. Explict database link the syntax is :- CREATE DATABASE LINK db link name CONNECT USING user_name identified by passwd USING connect_string; Default database link the syntax is :- CREATE DATABASE LINK db link name CONNECT USING current_user USING connect_string; In this case, it will try to connect to the remote database with the user_name / passwd of the local database currently logged in. to access table /view/synonym from a remote db use select * from table_name/view_name@dblink_name; But to make this db link and then to access first make the connect string of the remote database in the local machine in the tnsnames.ora using net 8 easy configuration tool. --- Saurabh Sharma [EMAIL PROTECTED] wrote: hi all, can any body has idea of how to create db links. we have 4-5 servers some are test and some producn. while requiring some info from other DBs how do i refer them ythrough DBlinks. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html Do You Yahoo!? For regular News updates go to http://in.news.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?milind=20ambegaoker?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: db links...
Creating db link is pretty easy. This can be done easily by reading the documentation. On the other hand, think carefully to what you want to do. What do you want to access and who will access it. I've seen many clients not knowing who was accessing what because they have grant everything to public. --- Saurabh Sharma [EMAIL PROTECTED] a écrit : hi all, can any body has idea of how to create db links. we have 4-5 servers some are test and some producn. while requiring some info from other DBs how do i refer them ythrough DBlinks. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: db links...
thanks a lot. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 1:20 PM Hi, Create {public} database link LINK connect to remote_db_username identified by remote_db_username_password using 'connect_string_as_found_in_tnsnames_on_machine_where_you_create_database_l ink'; There may be some issues with global name settings that may force you to name the database link exactly the same as the global name of the remote database. jack Saurabh Sharma To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ssharma1@fcsl cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) td.com Subject: db links... Sent by: [EMAIL PROTECTED] om 05-07-2001 09:05 Please respond to ORACLE-L hi all, can any body has idea of how to create db links. we have 4-5 servers some are test and some producn. while requiring some info from other DBs how do i refer them ythrough DBlinks. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).