Re: re - posting ODM.DMS_QUEUE_TABLE question

dorit wrote:
> (i think i posted this question originally in the wrong group ...
> so i'm sending the question again ....)
>
>
> version 9.2.0.1
> windows 2000
>
> my database is running the following :
>
> select q_name, state, delay, expiration, rowid, msgid, dequeue_msgid,
> chain_no, local_order_no, enq_time, enq_tid, step_no, priority,
> exception_qschema, exception_queue, retry_count, corrid,
> time_manager_info, sender_name, sender_address, sender_protocol from
> ODM.DMS_QUEUE_TABLE where time_manager_info <= :1 and state != :2
> for update skip locked
>
>
> i couldn't find any info about ODM.DMS_QUEUE_TABLE table.
>
>
> can someone help me with this issue ....
>
>
> thanks .
>
>
> dornit

SQL> conn / as sysdba
Connected.
SQL> select count(*) from dba_users where user = 'ODM';

   COUNT(*)

          0

SQL> No.

Assuming you are runnning Advanced Queuing the table would have been created using dbms_aqadm.create_queue_table.

What do you want to know?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org