# Sharded Queue problem

**URL:** <https://forums.toadworld.com/t/sharded-queue-problem/56942>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [February 3, 2023, 4:26pm UTC](https://forums.toadworld.com/t/sharded-queue-problem/56942 "2023-02-03T16:26:55Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![sdstuber](https://avatars.discourse-cdn.com/v4/letter/s/35a633/32.png) [@sdstuber](https://forums.toadworld.com/u/sdstuber)\
**Post date:** [February 3, 2023, 4:26pm UTC](https://forums.toadworld.com/t/sharded-queue-problem/56942/1 "2023-02-03T16:26:56Z")

</div>

When an AQ sharded queue is created, there is nothing that notes that in the schema browser and the script generation uses the wrong procedure to recreate them.

There doesn't appear to be an option to create one via the gui either.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 3, 2023, 4:31pm UTC](https://forums.toadworld.com/t/sharded-queue-problem/56942/2 "2023-02-03T16:31:01Z")

</div>

Hi Sean,

I added some sharding support to Toad 3 or 4 years ago. I don't recall doing anything special with Queues (or even seeing anything in the docs about it). But it was a while ago - maybe something was added to latest version (or maybe I just missed it!)

Can you give me an example of the command you're using to create a sharded queue?

Thanks

-John

---

<div class="post-metadata">

**Author:** ![sdstuber](https://avatars.discourse-cdn.com/v4/letter/s/35a633/32.png) [@sdstuber](https://forums.toadworld.com/u/sdstuber)\
**Post date:** [February 3, 2023, 4:31pm UTC](https://forums.toadworld.com/t/sharded-queue-problem/56942/3 "2023-02-03T16:31:54Z")

</div>

BEGIN  
DBMS\_AQADM.create\_sharded\_queue(  
queue\_name =\> 'MY\_SHARDED\_QUEUE',  
max\_retries =\> 5,  
multiple\_consumers =\> FALSE,  
queue\_payload\_type =\> DBMS\_AQADM.jms\_type  
);  
END;

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 3, 2023, 4:44pm UTC](https://forums.toadworld.com/t/sharded-queue-problem/56942/4 "2023-02-03T16:44:49Z")

</div>

Yeah, I definitely don't have support for that in Toad. I'll log it and try to get to it soon.

Please let me know if you notice anything else that's not supported, shard-wise.

Thanks

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 9, 2023, 7:42pm UTC](https://forums.toadworld.com/t/sharded-queue-problem/56942/5 "2023-02-09T19:42:55Z")

</div>

Hey Sean,

I am trying to set this up on a system-managed sharded db (19c) and am running into this. Oracle is giving me an error for a non-allshard user, but I am an all-shard user. Did you run into this? Which Oracle version are you using? I don't see anything helpful online about this.

 ![image](https://global.discourse-cdn.com/quest/original/2X/f/f5a852652431be2a12a0c59eb57e40818d089c73.png)

---

<div class="post-metadata">

**Author:** ![sdstuber](https://avatars.discourse-cdn.com/v4/letter/s/35a633/32.png) [@sdstuber](https://forums.toadworld.com/u/sdstuber)\
**Post date:** [February 9, 2023, 9:47pm UTC](https://forums.toadworld.com/t/sharded-queue-problem/56942/6 "2023-02-09T21:47:29Z")

</div>

The database doesn't need to be sharded.

Within AQ, "sharding" has its own meaning unrelated to database sharding.

The database I was using is not sharded.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 9, 2023, 9:50pm UTC](https://forums.toadworld.com/t/sharded-queue-problem/56942/7 "2023-02-09T21:50:57Z")

</div>

Oh! Well, that makes things a lot simpler!

Thanks.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 13, 2023, 8:47pm UTC](https://forums.toadworld.com/t/sharded-queue-problem/56942/8 "2023-02-13T20:47:38Z")

</div>

Hi Sean -

We added support for Sharded Queues in today's beta, which you can get [here](https://forums.toadworld.com/t/toad-for-oracle-16-3-beta/41283).

-John