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

Home -> Community -> Usenet -> c.d.o.server -> Re: What is Constraint type O ?

Re: What is Constraint type O ?

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Tue, 15 May 2001 09:10:18 +0500
Message-ID: <9dq6gu$l99$1@Services.ktnet.kg>

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)

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com


> I niticed that there are contraint type O (other than P - Primary, U -
> Unique, F - Foreign ...)
>
> TABLE_NAME Constraint type
> ------------------------------ ------------------
> AQ$DEF$_AQCALL O
> AQ$DEF$_AQERROR O
>
> Is this type used by Oracle system (not by users)?
> Thanks
> Tom
Received on Mon May 14 2001 - 23:10:18 CDT

Original text of this message

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