Re: Have you heard about constraint type 'O'

  • From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
  • To: tpandian@xxxxxxxxx
  • Date: Fri, 28 Jan 2005 16:52:39 -0500

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 of the constraint definition







Name of the constraint definition





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)







Name associated with the table (or view) with constraint definition





Text of search condition for a check constraint





Owner of table referred to in a referential constraint





Name of the unique constraint definition for referenced table





Delete rule for a referential constraint (|CASCADE| or |NO ACTION|)





Enforcement status of constraint (|ENABLED| or |DISABLED|)





Whether the constraint is deferrable





Whether the constraint was initially deferred





Whether all data obeys the constraint (|VALIDATED| or |NOT VALIDATED|)





Whether the name of the constraint is user or system generated





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 





Whether an enabled constraint is enforced or unenforced.

*See Also:* the /constraints/ in /Oracle9i SQL Reference 





When the constraint was last enabled or disabled





Name of the user owning the index





Name of the index

So, my advice is: Read The F(ine) Manual.

Mladen Gogala
Oracle DBA
Ext. 121


Other related posts: