Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I control the tablespaces in which the queue tables are created?

April 26, 2017CONTROL Queue tables tablespaces

0

Posted

How can I control the tablespaces in which the queue tables are created?

1 Answer

0

Posted

You can pick a tablespace for storing the queue table and all its ancillary objects using the storage_clause parameter in DBMS_AQADM.CREATE_QUEUE_TABLE. However, once you pick the tablespace, all IOTs and indexes created for that queue table will go to the specified tablespace. Currently, you do not have a choice to split them between different tablespaces.