Hello,

My system is a 9.2.0.1.0 database on Windows/XP.  I imported an schema and after finishing with it I tried to drop the user.  The import came from an 8.1.7.4 system.  I even tried to drop the tablespace!  I can't!

Yes, I did the "cascade" on the drop user.  Yes, I did the "including contents and datafiles cascade constraints" on the drop tablespace.

I get the following messages:

ORA-24008 queue table string.string must be dropped first

Cause: An error was detected when dropping a queue table in a cluster, tablespace, or schema.

Action: Use the DBMS_AQADM.DROP_QUEUE_TABLE procedure to drop the specified queue table first; then, retry the operation.

and

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

Cause: An attempt was made to use the SQL command DROP TABLE for queue tables, but DROP TABLE is not supported for queue tables.

Action: Use the DBMS_AQADM.DROP_QUEUE_TABLE procedure instead of the DROP TABLE command.


These procedures fail with:

PLS-00357 Table,View Or Sequence reference 'string' not allowed in this context

Cause: A reference to database table, view, or sequence was found in an inappropriate context. Such references can appear only in SQL statements or (excluding sequences) in %TYPE and %ROWTYPE declarations. Some valid examples follow:

SELECT ename, emp.deptno, dname INTO my_ename, my_deptno, my_dept
FROM emp, dept WHERE emp.deptno = dept.deptno;
DECLARE
last_name  emp.ename%TYPE;
dept_rec   dept%ROWTYPE;


Action: Remove or relocate the illegal reference.


The problem is I can't even look at dbms_aqadm as it is inside of a wrapper.  I didn't write the procedure - Oralce did.

I looked inside the export file and found the create table command is using undocumented paramters (at least on 8.1.7 (the export system)).  The parameter is "USAGE QUEUE."  The thing is this queue table existgs without using a dbms_aqadm.create_queue or create_queue_table.

I'm  not looking to rebuild my database OR hose it up with some "event trap."  (Been there before in both cases.)  Well, maybe in the worse case.  I'd like to know my options and why?!