| Error 942 happened during loading of queue [message #65911] |
Sat, 29 January 2005 06:33  |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
Hi, i was getting the error
"kwqiclode: Error 942 happened during loading of queue"
in the Alert log very frequently(almost very minute).
I checked the trace file it showed
"Error 942 in Queue Table QS.QS_ORDERS_PR_MQTAB"
I checked the table that was used by a view QS.AQ$QS_ORDERS_PR_MQTAB
and the view was refrerring another table QS.AQ$_QS_ORDERS_PR_MQTAB_S which doesnt exists
in the database so i created the table(copied structure from another instance)
and recompiled the view now i am not getting this error.
Can anyone tell me whats the meaning of the above error and whats the purpose
of above view and for what the user QS is used.
Is it related to Locking on tables as initially there was too much locking
showed in OEM but now it has reduced.
Please let me know its very urgent for me
Thanks in advance
Vivek
|
|
|
|
| Re: Error 942 happened during loading of queue [message #65913 is a reply to message #65911] |
Mon, 31 January 2005 06:15  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
I beleive, you are talking about the QS* schemas , that are installed along with seed database ( or database with all default options). If so, it just an sample schema, built and supplied by oracle for educational/demonstration purposes purposes.
You can remove them, if you dont need them. I beleive
$ORACLE_HOME/demo/schema/shipping/qs_drop.sql will gracely remove all the queing related schemas.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
