Dropping user !

[niranjan]

Hai all,

I had got a user which had some queue tables.I tried to drop that user and I got the error,
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables

Then I used this procedure and dropped the queue tables successfully and checked out in the tables USER_QUEUE_TABLES as well as in DBA_QUEUE_TABLES.now there are no entries in both these tables.

Then I checked out in OBJ$ and I found entries in that.
the tablenames are DEF$_AQCALL, DEF$_AQERROR.
Actually I think these two are default tables available in system under dba_queue_tables.
these are the same tables which are also had been in my user.

SVRMGR> select count(*) from obj$ where name like '%DEF$_AQCALL%';
COUNT(*)
----------
3
1 row selected.

SVRMGR> select count(*) from obj$ where name like '%DEF$_AQERROR%';
COUNT(*)
----------
1
1 row selected

can I remove the entry in the obj$?
Kindly let me know how to remove this user.

Regards and thanx,
Niranjan.

[davey23uk]

this was discussed a few days ago, do a search for it