From oracle-l-bounce@freelists.org Mon Aug 8 09:36:08 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j78Ea8iL006786 for ; Mon, 8 Aug 2005 09:36:08 -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 j78Ea3IP006767 for ; Mon, 8 Aug 2005 09:36:03 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BA1DF1DD14E; Mon, 8 Aug 2005 09:36:00 -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 05160-05; Mon, 8 Aug 2005 09:36:00 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B77C61DD2AC; Mon, 8 Aug 2005 09:35:59 -0500 (EST) To: oracle-l@freelists.org Subject: REFERENCEing a system table MIME-Version: 1.0 Message-ID: From: "Leandro Guimaraes Faria C. Dutra" Date: Mon, 8 Aug 2005 11:30:03 -0300 X-MIMETrack: Serialize by Router on TDBKDD08/TDB(Release 6.5.1|January 21, 2004) at 08/08/2005 11:26:20 AM, Serialize complete at 08/08/2005 11:26:20 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: 23547 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 I just mentioned it in another message, but I thought it would be nice to ask if there is a way out -- until now I've been assumed it is just an arbitrary restriction coupled to an Oracle modelling defect and have let the issue to rest. All of you are familiar with DBA_TABLESPACES, and know that it is based on SYS.TS$. I want to store historical data from DBA_TABLESPACE_USAGE_METRICS, and I would like to avoid letting garbage in it by a CONSTRAINT REFERENCES on TABLESPACE_NAME. The problem is that view constraints can't be enabled, and a CONSTRAINT REFERENCES needs an enabled constraint to be itself enabled; and on the other hand TS$ doesn't have a primary key, and I don't really want to ALTER it, it being internal. Should I just forget my CONSTRAINT REFERENCES ENABLE? It will be quite harmless to leave it DISABLEd anyway, I guess... By the way, it seems quite strange to me that Oracle itself doesn't declare PRIMARY KEYs on its internal tables. -- 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