Re: CANNOT DROP USER (ENQUEUING)

_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