dropping user..

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

what's the error?

did you try drop user cascade?

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

hi

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

Quote:

---

Originally posted by prasadvd
hi

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

---

post the dang statement and error please!!!!

hi

i tried drop user cascade. then it ask me

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

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.

hi amar,

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

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

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

Quote:

---

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

---

WOW! How was your weekend?

:D

MH

Looks as though your are using Oracle Advanced queing.

does the user your are trying to drop own any queue tables?

select owner,queue_table,type from dba_queue_tables;

If this is the case then you must use the DBMS_AQADM.DROP_QUEUE_TABLE procedure.