From oracle-l-bounce@freelists.org Fri Jan 28 15:10:39 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0SLAdRN030916 for ; Fri, 28 Jan 2005 15:10:39 -0600 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 j0SLAcem030908 for ; Fri, 28 Jan 2005 15:10:38 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D7A7168512; Fri, 28 Jan 2005 15:09:48 -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 19828-01; Fri, 28 Jan 2005 15:09:48 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5BE60679E0; Fri, 28 Jan 2005 15:09:48 -0500 (EST) Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410511E74F@usahm236.amer.corp.eds.com> From: "Powell, Mark D" To: "'tpandian@gmail.com'" , Oracle-L@freelists.org Subject: RE: Have you heard about constraint type 'O' Date: Fri, 28 Jan 2005 15:07:51 -0500 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 15432 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mark.powell@eds.com Precedence: normal Reply-To: mark.powell@eds.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at example.com X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: Type "O" is for READ ONLY on a view per the Oracle 10g Reference Manual -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Thiru Pandian Sent: Friday, January 28, 2005 2:55 PM To: Oracle-L@freelists.org Subject: Have you heard about constraint type 'O' I was browsing through Oracle 11i applsys schema and i found there is a constraint type called O . I saw all the constraint belongs to this type for AQ tables. I do not see any oracle documentation for this type. Any body know what for this used?. -- Thiru Pandian Sr. Oracle DBA -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l