Re: Enable/Disble a Queue?

Do either of the following to enable the queue returned in the ORA-25207 error:

    You can use the Oracle Enterprise Manager (OEM) Schema Manager,     schema System, then select the queue name and enable it.

• OR --

    You can manually execute
    DBMS_AQADM.START_QUEUE(queue_name=>'<TABLE_NAME').

Regards

"The Views expressed here are my own and not necessarily those of Oracle Corporation"

Regards

"The Views expressed here are my own and not necessarily those of Oracle Corporation"

Chuck Wessel <wessel_at_yuck.net> wrote in message news:Swpi3.2738$U5.521319_at_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 Sun Jul 18 1999 - 21:43:26 CDT