Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id B2743196030A for ; Mon, 3 Mar 2014 18:23:54 +0100 (CET) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTP for ; Mon, 3 Mar 2014 18:23:54 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 70E02282A1; Mon, 3 Mar 2014 12:23:53 -0500 (EST) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id H9cuzek8AMpB; Mon, 3 Mar 2014 12:23:53 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7F9A5281B3; Mon, 3 Mar 2014 12:23:10 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 03 Mar 2014 12:22:28 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 49FD128008 for ; Mon, 3 Mar 2014 12:22:28 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id IRmQEvfn0RzZ for ; Mon, 3 Mar 2014 12:22:28 -0500 (EST) Received: from nm2-vm5.access.bullet.mail.bf1.yahoo.com (nm2-vm5.access.bullet.mail.bf1.yahoo.com [216.109.114.92]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E48A4267EB for ; Mon, 3 Mar 2014 12:22:27 -0500 (EST) Received: from [66.196.81.155] by nm2.access.bullet.mail.bf1.yahoo.com with NNFMP; 03 Mar 2014 17:22:27 -0000 Received: from [98.138.104.98] by tm1.access.bullet.mail.bf1.yahoo.com with NNFMP; 03 Mar 2014 17:22:27 -0000 Received: from [127.0.0.1] by smtp118.sbc.mail.ne1.yahoo.com with NNFMP; 03 Mar 2014 17:22:27 -0000 X-Yahoo-Newman-Id: 44805.10130.bm@smtp118.sbc.mail.ne1.yahoo.com X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: ajFKYz0VM1nRyTQZY1yyRwiKgyVFAD.iaQqcu9RV6sDt0Uu Yyrqsxys9yojHPn4yUrMRUPmUNV1Vry0nEqXm6wr6grdvhMrYqMC5SEnZRYO FGqC803MiGpQgM7..jRvYJuETNqMbWkASLpj3.TIyyq0UniLkaao_aVLm46X rxjnMrRTPrTVpYk2Q5_KTeRhF6Z31BtNqyf17GDIBsDWgpcV6e1p08_LnB.0 V7XcTTBLG_KCc96gIaJslvgtW5m5MjLP_9cMnho1Ev6zqNwmWPAXuGGSodMW nHjWZzENCjyFBsYU.QT8h4VGeZWRRRtiWYSFeiDWlq3bCs9ycvgm1BabXJDz 6dBsHfneSPtZAxpPVu946nGcSzn7WdD5.Y6Y0OzsbG5EPLutCLY5QD0DP1Ay 1R2LXZ0XHU7AnSQmknGj_ftIYzow_Q.WjoI4cddHhK94ejY4ZqpDxe5qwcS_ eeX.SaC2SxImy7U5jTUBEM_jj9uQP8S_uzz09D5qFkZXzCsVsqlacLf0sFVo HgNassunFgu8jDBbxxgedkbbvHY4.1dSzB8UCnz1mFyMGap2bc29VNb5.lq. 87iwDZ1tH8s.hTjk2G3X.W.kqK5rcYTKYpL5gQX6XZUtZNlS76Wfb1iFcNzz HsYToon7SP8OzYeJhuGCnhrr2b6cbQ5R4Dku1eD1CgOOh7Do0oPRDTLLhQxs sGU4VkiNqapwPA.sctJoFORrIhKd.Y8P9us9gT9h_ZnbhJNANKkLYxjCAVQf YhL5TcT76GmA4xJ8zRTr_6USKTA5QT54uG3wBh_7K1bGJWLarjQGEBSpcHHE Zlh6gy2aONVoW92D.OF39ghskX1YU X-Yahoo-SMTP: jILYxN6swBByoLMomwepBoHEgNu7kHZ7mGDgS5dRhv4m4w-- X-Rocket-Received: from society.servebeer.com (rjoralist3@108.209.12.222 with plain [98.138.31.74]) by smtp118.sbc.mail.ne1.yahoo.com with SMTP; 03 Mar 2014 17:22:27 +0000 UTC Received: from society.servebeer.com (localhost [127.0.0.1]) by society.servebeer.com (Postfix) with ESMTP id D6FF7E372D for ; Mon, 3 Mar 2014 11:22:25 -0600 (CST) Received: from 24.106.30.84 (SquirrelMail authenticated user rjesse) by society.servebeer.com with HTTP; Mon, 3 Mar 2014 11:22:25 -0600 (CST) Message-ID: Date: Mon, 3 Mar 2014 11:22:25 -0600 (CST) Subject: SYS_CONTEXT DBLINK_INFO returns null over db link From: "Rich Jesse" To: oracle-l@freelists.org User-Agent: SquirrelMail/1.4.17 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-archive-position: 53221 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: rjoralist3@society.servebeer.com Precedence: normal Reply-To: rjoralist3@society.servebeer.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l Hey all, In 11.2.0.3, I'm trying to determine where a query over a dblink originat= ed using: SELECT SYS_CONTEXT('USERENV','DBLINK_INFO') FROM DUAL@REMDB; ...but it always returns a NULL. This is documented at: http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions184.htm Anyone know where else I could get this info? Well, other than X$ tables= as specified in: http://jkstill.blogspot.com/2010/03/whos-using-database-link.html Not sure I want to go there if'n I don't have to... TIA! Rich -- http://www.freelists.org/webpage/oracle-l