From oracle-l-bounce@freelists.org Mon Aug 8 07:33:50 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j78CXnFO018652 for ; Mon, 8 Aug 2005 07:33:49 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j78CXiIP018635 for ; Mon, 8 Aug 2005 07:33:44 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D18351DCDB9; Mon, 8 Aug 2005 07:33:41 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03789-09; Mon, 8 Aug 2005 07:33:41 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 586251DD40C; Mon, 8 Aug 2005 07:33:41 -0500 (EST) In-Reply-To: <445F36B0271AE1419CEE0B9589044B433747DD@TYGRRA01-XCS00.telkom.co .za> To: VerreyB@telkom.co.za Cc: oracle-l@freelists.org, oracle-l-bounce@freelists.org Subject: Views on public synonyms (Was: OCFS2) MIME-Version: 1.0 Message-ID: From: "Leandro Guimaraes Faria C. Dutra" Date: Mon, 8 Aug 2005 09:27:42 -0300 X-MIMETrack: Serialize by Router on TDBKDD08/TDB(Release 6.5.1|January 21, 2004) at 08/08/2005 09:24:01 AM, Serialize complete at 08/08/2005 09:24:01 AM Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-archive-position: 23530 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ldutra@toyota.com.br Precedence: normal Reply-To: ldutra@toyota.com.br X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.9 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 oracle-l-bounce@freelists.org gravou em 2005-08-08 02:19:25: > The developers neglected to tell me that they were using public > synonyms (not my orginal database - they also had sysdba access) and > views based on these public synonyms. So the production stuff was > broken on the new instance. As a result they thought that synonyms and > views were a problem in Oracle and simply stopped using them at all in > new developments. Until I found out and managed to fix their > perceptions. While I understand quite well that one error situation shouldn't be generalised, I fail to see what should be the problem with views on public synonyms. Do they happen not to work on Oracle at all, on the SQL standards, on a specific version of Oracle? Is that by design or just a know bug (like undifferentiated NULLs or pointers or class == table at the SQL standards level)? There are somethings I trip over now and then, but quite often I find them to be either SQL or Oracle bugs at the conceptual level -- like when I wanted to store a historical series of storage allocation and usage by tablespace, with an enabled foreign key to dba_tables or something, and couldn't. -- Leandro Guimarães Faria Corcete DUTRA Administrador de Bases de Dados +55 (11) 4390 5383 Toyota do Brasil Ltda ldutra@toyota.com.br São Bernardo do Campo, SP BRASIL This message (including any attachments) is confidential and may be privileged and intended solely for the use of the person/entity to whom it is addressed. If you have received it by mistake please notify the sender by returning via e-mail as well as delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is prohibited. Please note that e-mails are susceptible to change. TOYOTA DO BRASIL LTDA (including its group companies) shall not be liable for the improper or incomplete transmission of the information contained in this communication, neither for personal, nonbusiness related information nor opinion sent through this email or even for any delay in its receipt or damage to your system. TOYOTA DO BRASIL LTDA (or its group companies) does not guarantee that the integrity of this communication has been kept nor that this communication is free of viruses, interceptions or interference. -- http://www.freelists.org/webpage/oracle-l