-
Help... dropping SC and MC advanced queues...
Some customer has sent us an exp of there database, which imported..
Now the problem is on starting our client software we getting:
OCI Error ORA-25205: the QUEUE SWPRO.SW_SYSTEM_EVENTS does not exist
Now this is created with:
DBMS_AQADM.CREATE_NP_QUEUE('sw_system_events', TRUE, NULL);
DBMS_AQADM.START_QUEUE('sw_system_events');
And in the schema they do exist.. I think the problem is that in user_queues they do not show up.. ? i assume they have refernce back into the sys schema, that i didn;t import.. So i tryed:
EXECUTE dbms_aqadm.stop_queue (queue_name => 'sw_system_events');
EXECUTE dbms_aqadm.drop_queue (queue_name => 'sw_system_events');
and i get the message back they do not exist.. but they do..
I think its only these NP queues that cause this problem? maybe..
Thanks...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|