What is Constraint type O ?

What is Constraint type O ?

Post by Tom » Wed, 16 May 2001 10:48:56



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

 
 
 

What is Constraint type O ?

Post by Michel Cado » Wed, 16 May 2001 16:19:36




Quote:> 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

Constraint O is Read Only constraint on view.

v815> select text from dba_views where view_name='AQ$DEF$_AQCALL';

TEXT
--------------------------------------------------------------------------------
SELECT q_name QUEUE, msgid MSG_ID, corrid CORR_ID, priority MSG_PRIORITY, decode
(state, 0,   'READY',
                                1,   'WAIT',
                                2,   'PROCESSED',
                                3,   'EXPIRED') MSG_STATE, delay, expiration, en
q_time, enq_uid ENQ_USER_ID, enq_tid ENQ_TXN_ID, deq_time, deq_uid DEQ_USER_ID,
deq_tid DEQ_TXN_ID, retry_count, exception_qschema EXCEPTION_QUEUE_OWNER, except
ion_queue, user_data FROM SYSTEM.DEF$_AQCALL WITH READ ONLY

--
Have a nice day
Michel

 
 
 

What is Constraint type O ?

Post by Michel Cado » Wed, 16 May 2001 16:19:36




Quote:> 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

Constraint O is Read Only constraint on view.

v815> select text from dba_views where view_name='AQ$DEF$_AQCALL';

TEXT
--------------------------------------------------------------------------------
SELECT q_name QUEUE, msgid MSG_ID, corrid CORR_ID, priority MSG_PRIORITY, decode
(state, 0,   'READY',
                                1,   'WAIT',
                                2,   'PROCESSED',
                                3,   'EXPIRED') MSG_STATE, delay, expiration, en
q_time, enq_uid ENQ_USER_ID, enq_tid ENQ_TXN_ID, deq_time, deq_uid DEQ_USER_ID,
deq_tid DEQ_TXN_ID, retry_count, exception_qschema EXCEPTION_QUEUE_OWNER, except
ion_queue, user_data FROM SYSTEM.DEF$_AQCALL WITH READ ONLY

--
Have a nice day
Michel