Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What is Constraint type O ?
"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
1, 'WAIT', 2, 'PROCESSED', 3, 'EXPIRED') MSG_STATE, delay, expiration, enq_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 MichelReceived on Tue May 15 2001 - 02:19:36 CDT