Oracle Streams Advanced Queuing
-- 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;
/


Oracle registered trademark of Oracle Corporation.

Last Revised On: August 01, 2008

  1441