Re: CANNOT DROP USER (ENQUEUING)

From: Ed Prochak <edprochak_at_gmail.com>
Date: 13 Sep 2006 10:45:55 -0700
Message-ID: <1158169555.311427.97830@d34g2000cwd.googlegroups.com>

_phil_ wrote:
> no more !
>
> SQL> execute
> dbms_aqadm.DROP_QUEUE_TABLE(queue_table=>'TESTAQ$_ESS_CLI_FAC_QUEUE_TABLE1_H',force=>TRUE);
> BEGIN
> dbms_aqadm.DROP_QUEUE_TABLE(queue_table=>'TESTAQ$_ESS_CLI_FAC_QUEUE_TABLE1_H',force=>TRUE);
> END;
>
> *
> ERROR at line 1:
> ORA-24019: identifier for QUEUE_TABLE too long, should not be greater
> than 24 characters
> ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2699
> ORA-06512: at "SYS.DBMS_AQADM", line 192
> ORA-06512: at line 1
>
> SQL>
>
> same with
> dbms_aqadm.DROP_QUEUE_TABLE(queue_table=>'TESTAQ$_ESS_CLI_FAC_QUEUE_TABLE1_H');
>
>
> g wrote:
> > what happens if you leave the aq$ in
> > dbms_aqadm.DROP_QUEUE_TABLE(queue_table=>'TESTAQ$_ESS_CLI_FAC_QUEUE_TABLE1_H')
> >

shouldn't that table name include a period??? dbms_aqadm.DROP_QUEUE_TABLE(queue_table=>'TEST.AQ$_ESS_CLI_FAC_QUEUE_TABLE1_H'); (period located after TEST and before AQ)

HTH
ed
Don't you just hate typos? When will we get a DWIM,NWIS interface? (Do What I Mean, Not What I Say) Received on Wed Sep 13 2006 - 12:45:55 CDT