Re: How to enable AQ?

Kris Jenkins wrote:

> Hi,
>
> I'm trying to learn about Advanced Queuing (AQ) by running the supplied
> demo ($ORACLE_HOME/rdbms/demo/aqdemo00.sql), but I get this error:
>
> Creating Queue Table input_queue_table...
> Oracle Server Error = -439
> Oracle Server Message = Create Queue Table ORA-00439: feature
> not enabled:
> Database queuing
>
> Looking in V$OPTION I see:
>
> Database queuing FALSE
>
> But I've no idea how to remedy that - I've tried uninstalling and
> re-installing from the standard installer, but no luck.
>
> I'm using Oracle 8i (8.1.7.0.1), btw.
>
> Can anyone suggest anything, please?
>
> Kris

Purhase the 9i CD set at http://store.oracle.com for about $35 US. The chances of downloading anything as large as 9i EE from Oracle for the next month is not great. ;-)

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)