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