Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Create Oracle AQ in oracle XE 10.2.0.1.0

871904Jun 29 2011
i am try to create Advanced Queue in oracle xe 10.2.0.1.0 .

for that i need one clarification.whatever i mensiond in the below packeges.
is it required to create Queue?.
if it is required. how we get this in our database.
is this packeges automatically availble whenever instaled the oracle xe 10.2.0.1.0.

1.DBMS_AQ
2.DBMS_AQADM

2. Question: i am try to create AQ in oracle XE 10.2.0.1.0

Fallow the below steps:

1.CREATE USER testq IDENTIFIED BY x;
2.GRANT connect, resource, dba TO testq;
3.GRANT aq_administrator_role, aq_user_role TO testq;
4.GRANT create type TO testq;

After 4 step i execute below sql command.getting the error .

Error is : ORA-00942: table or view does not exist .why i am getting this error.

CREATE OR REPLACE TYPE event_msg_type AS OBJECT (
name VARCHAR2(10),
current_status NUMBER(5),
next_status NUMBER(5)
);


pls help me on this ASAP.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 27 2011
Added on Jun 29 2011
0 comments
128 views