FW: Have you heard about constraint type 'O'

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: "'Oracle-L@xxxxxxxxxxxxx'" <Oracle-L@xxxxxxxxxxxxx>
  • Date: Fri, 28 Jan 2005 15:17:04 -0500

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

Other related posts: