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: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 15 May 2001 09:19:36 +0200
Message-ID: <9dqla9$u28$1@s1.read.news.oleane.net>

"Tom" <cmc3232_at_yahoo.com> a écrit dans le message news: cW%L6.34085$yw.930977_at_news20.bellglobal.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
>
>
>

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
Received on Tue May 15 2001 - 02:19:36 CDT

Original text of this message

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