Enable/Disble a Queue?

From: Chuck Wessel <wessel_at_yuck.net>
Date: Mon, 12 Jul 1999 12:16:07 -0500
Message-ID: <Swpi3.2738$U5.521319@ptah.visi.com>

Without boring you with too much detail, I have a replicated environment. While refreshing a snapshot refresh group, I must have "overflowed" a queue or something. I could use some help.

The error message looks like this:

    /*****

    ORA-23324: error ORA-25207: enqueue failed, queue SYSTEM.DEF$_AQERROR is disabled from enqueueing

    ORA-06512: at "SYS.DBMS_DEFER_ENQ_UTL", line 104
    ORA-06512: at "SYS.DBMS_DEFER_INTERNAL_SYS", line 450, while creating
deferror entry at "OAPT.WORLD" with error -1048
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 380
    ORA-06512: at "SYS.DBMS_IREFRESH", line 450
    ORA-06512: at "SYS.DBMS_REFRESH", line 182

    ORA-06512: at line 2

*****/

The help info for ORA-25207 looks like this:

    ORA-25207: enqueue failed, queue name.name is disabled from enqueueing

    Cause: The queue has been stopped to prevent any further enqueueing.

    Action: Enable the queue first by using an administrative operation.

I don't know how to re-enable the queue. I've looked through a lot of documentation (electronic and paper), and scoured deja.com and oracle's (free) support area. I'm certainly no DBA so perhaps queue-enabling is too basic to mention? I hope this group can give me a clue...

Thanks in advance,

Chuck Wessel Received on Mon Jul 12 1999 - 12:16:07 CDT