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

  • From: Thiru Pandian <tpandian@xxxxxxxxx>
  • To: mark.powell@xxxxxxx
  • Date: Fri, 28 Jan 2005 15:28:56 -0500

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@xxxxxxx> 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@xxxxxxxxx'; Oracle-L@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Thiru Pandian
> Sent: Friday, January 28, 2005 2:55 PM
> To: Oracle-L@xxxxxxxxxxxxx
> 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
> --
> //www.freelists.org/webpage/oracle-l
> 
> --
> //www.freelists.org/webpage/oracle-l
> 


-- 
Thiru Pandian 
Sr. Oracle DBA
--
//www.freelists.org/webpage/oracle-l

Other related posts: