dropping user..

[prasadvd]

hi

how to delete queue tables from user ? i want to drop a user from my database which doesn't allow me to drop . it ask me to delete queue tables first .


an immediate reply is appreciated.


Thanx in adv

[stmontgo]

what's the error?

did you try drop user cascade?

[adewri]

Some more details will be appreciated like error message ?? Oracle version ??

[prasadvd]

hi

it ask me to use DBMS_AQADM.DROP_QUEUE_TABLE procedure...

[stmontgo]

Originally posted by prasadvd
hi

it ask me to use DBMS_AQADM.DROP_QUEUE_TABLE procedure...

post the dang statement and error please!!!!

[prasadvd]

hi

i tried drop user cascade. then it ask me

ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables

[adewri]

Try this

1. Log into SQL*Plus or Server Manager as a user with DBA privileges.

2. Issue command:

alter session set events '10851 trace name context forever ,level 2';

3. Drop table queue_table;

4. Then drop the user.

[prasadvd]

hi amar,

i have already gone through ur procedure. but, it did not work out.
still im getting same error. any more pls...?

[adewri]

Why do you waste time, does it hurt to give more details like what Oracle version, what OS etc ???

[adewri]

BTW did you try DBMS_AQADM.DROP_QUEUE_TABLE procedure to drop the queue table ??