Help - Search - Members - Calendar
Full Version: Queue Table
Oracle DBA Forums > Oracle > Oracle Forum
yadav2408
I have created queue table using below script


BEGIN
SYS.DBMS_AQADM.CREATE_QUEUE_TABLE (
QUEUE_TABLE => 'scott.NG_MSG_QUEUE_TBL',
QUEUE_PAYLOAD_TYPE => 'SYS.AQ$_JMS_TEXT_MESSAGE',
COMPATIBLE => '10.0.0',
STORAGE_CLAUSE => 'TABLESPACE MEDIUM_DATA',
SORT_LIST => 'ENQ_TIME',
MULTIPLE_CONSUMERS => FALSE,
MESSAGE_GROUPING => 0,
SECURE => FALSE
);
END;




Indexes
--------

INDEX_NAME TABLESPACE_NAME
------------------------------ --------------------------
AQ$_NG_MSG_QUEUE_TBL_T MEDIUM_DATA
AQ$_NG_MSG_QUEUE_TBL_I MEDIUM_DATA
SYS_IL0001100359C00037$$ MEDIUM_DATA
SYS_IL0001100359C00040$$ MEDIUM_DATA
SYS_IL0001100359C00041$$ MEDIUM_DATA
SYS_C0073180 MEDIUM_DATA


I want all the index to be created in different tablespace like 'medium_index.

can we specify tablespace for index when we are creating queue table.


Thanks for valuable suggestion.
burleson
Hi

As you sdee each invocsation of dbms_adadm.create _queue_table goves you the opportunity to use brand-new fresh storage from the storge_clause.

I want all the index to be created in different tablespace like 'medium_index.

Good idea, for better mgt and monitorng.


READ:

http://www.dba-oracle.com/t_choose_queue_tablespace_size.htm
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.