-- Create table (Inbound) BEGIN SYS.DBMS_AQADM.CREATE_QUEUE_TABLE (queue_table => 'EDW.QT_DWDL_INBOUND', queue_payload_type => 'SYS.AQ$_JMS_TEXT_MESSAGE', sort_list => 'DWDL_CTIME', multiple_consumers => true, compatible => '10.0.0', primary_instance => 0, secondary_instance => 0, storage_clause => 'tablespace EDW_DATA_32K '|| 'pctfree 10 initrans 1 maxtrans 255 '|| 'storage ( initial 80K minextents 1 maxextents unlimited )'); END; / -- Create table (Outbound) BEGIN SYS.DBMS_AQADM.CREATE_QUEUE_TABLE (queue_table => 'EDW.QT_DWDL_OUTBOUND', queue_payload_type => 'SYS.AQ$_JMS_TEXT_MESSAGE', sort_list => 'DWDL_CTIME', multiple_consumers => true, compatible => '10.0.0', primary_instance => 0, secondary_instance => 0, storage_clause => 'tablespace EDW_DATA_32K '|| 'pctfree 10 initrans 1 maxtrans 255 '|| 'storage ( initial 80K minextents 1 maxextents unlimited )'); END; /
73923