Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: FW: Have you heard about constraint type 'O'

Re: FW: Have you heard about constraint type 'O'

From: Thiru Pandian <tpandian_at_gmail.com>
Date: Fri, 28 Jan 2005 15:28:56 -0500
Message-ID: <1d23e2cc050128122844812a2@mail.gmail.com>


Really.. I searched through 9.2.0 documentation as we are running 9.2.0.4 version and i could see anything. Thanks guys..

On Fri, 28 Jan 2005 15:17:04 -0500, Powell, Mark D <mark.powell_at_eds.com> wrote:
> I hit send too quick as you can also find this information in the Reference
> Manual entry for all_constraints in the version 8.0 documentation. I
> suspect that the type "O" and "V" entries go further back than that.
> Valid types are P, U, C, R, V, and O.
>
> HTH -- Mark D Powell --
>
>
> -----Original Message-----
> From: Powell, Mark D
> Sent: Friday, January 28, 2005 3:08 PM
> To: 'tpandian_at_gmail.com'; Oracle-L_at_freelists.org
> Subject: RE: Have you heard about constraint type 'O'
>
> Type "O" is for READ ONLY on a view per the Oracle 10g Reference Manual
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Thiru Pandian
> Sent: Friday, January 28, 2005 2:55 PM
> To: Oracle-L_at_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
>

-- 
Thiru Pandian 
Sr. Oracle DBA
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 28 2005 - 15:31:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US