From oracle-l-bounce@freelists.org Fri Jan 28 16:55:36 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0SMtaeI013819 for ; Fri, 28 Jan 2005 16:55:36 -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 j0SMtaem013815 for ; Fri, 28 Jan 2005 16:55:36 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1248168006; Fri, 28 Jan 2005 16:54:46 -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 15719-09; Fri, 28 Jan 2005 16:54:45 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8205A67FE8; Fri, 28 Jan 2005 16:54:45 -0500 (EST) Message-ID: <41FAB427.4010604@allegientsystems.com> Date: Fri, 28 Jan 2005 16:52:39 -0500 From: Mladen Gogala User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: tpandian@gmail.com Cc: Oracle-L@freelists.org Subject: Re: Have you heard about constraint type 'O' References: <1d23e2cc05012811555a1c4943@mail.gmail.com> In-Reply-To: <1d23e2cc05012811555a1c4943@mail.gmail.com> Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-archive-position: 15446 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mgogala@allegientsystems.com Precedence: normal Reply-To: mgogala@allegientsystems.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: Thiru Pandian wrote: >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?. > > I asked my friend F. Manual and here is what he said: *Column* *Datatype* *NULL* *Description* |OWNER| |VARCHAR2(30)| |NOT NULL| Owner of the constraint definition |CONSTRAINT_NAME| |VARCHAR2(30)| |NOT NULL| Name of the constraint definition |CONSTRAINT_TYPE| |VARCHAR2(1)| Type of constraint definition: * |C| (check constraint on a table) * |P| (primary key) * |U| (unique key) * |R| (referential integrity) * |V| (with check option, on a view) * |O| (with read only, on a view) |TABLE_NAME| |VARCHAR2(30)| |NOT NULL| Name associated with the table (or view) with constraint definition |SEARCH_CONDITION| |LONG| Text of search condition for a check constraint |R_OWNER| |VARCHAR2(30)| Owner of table referred to in a referential constraint |R_CONSTRAINT_NAME| |VARCHAR2(30)| Name of the unique constraint definition for referenced table |DELETE_RULE| |VARCHAR2(9)| Delete rule for a referential constraint (|CASCADE| or |NO ACTION|) |STATUS| |VARCHAR2(8)| Enforcement status of constraint (|ENABLED| or |DISABLED|) |DEFERRABLE| |VARCHAR2(14)| Whether the constraint is deferrable |DEFERRED| |VARCHAR2(9)| Whether the constraint was initially deferred |VALIDATED| |VARCHAR2(13)| Whether all data obeys the constraint (|VALIDATED| or |NOT VALIDATED|) |GENERATED| |VARCHAR2(14)| Whether the name of the constraint is user or system generated |BAD| |VARCHAR2(3)| A |YES| value indicates that this constraint specifies a century in an ambiguous manner. To avoid errors resulting from this ambiguity, rewrite the constraint using the |TO_DATE| function with a four-digit year. *See Also:* the |TO_DATE| function in /Oracle9i SQL Reference / and /Oracle9i Application Developer's Guide - Fundamentals / |RELY| |VARCHAR2(4)| Whether an enabled constraint is enforced or unenforced. *See Also:* the /constraints/ in /Oracle9i SQL Reference / |LAST_CHANGE| |DATE| When the constraint was last enabled or disabled |INDEX_OWNER| |VARCHAR2(30)| Name of the user owning the index |INDEX_NAME| |VARCHAR2(30)| Name of the index So, my advice is: Read The F(ine) Manual. -- Mladen Gogala Oracle DBA Ext. 121 -- http://www.freelists.org/webpage/oracle-l