2 Replies Latest reply: Nov 21, 2012 5:27 AM by xerces8 RSS

    Alter queue table (initrans) ?

    xerces8
      Hi!

      Is it possible to change the INITRANS value of a queue table after creation?

      If a table is created with DBMS_AQADM.CREATE_QUEUE_TABLE(...), how to change the INITRANS value after the fact?
      The DBMS_AQADM.ALTER_QUEUE_TABLE Procedure does not support this.

      Is the only way accessing the underlying DB table? (like ALTER TABLE AQ$_table_name_ INITRANS 100)

      It is on Oracle 11.2g

      Regards,
      David