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
Printable View
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...
post the dang statement and error please!!!!Quote:
Originally posted by prasadvd
hi
it ask me to use DBMS_AQADM.DROP_QUEUE_TABLE procedure...
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 ??