Good day all and thanks for any insight you can provide. I am predominantly a Microsoft DBA and find myself having to use Oracle XE to convert a competitors software over to MS-SQL for our application. I was able to get the restore done in XE 21c and converted all of the data over successfully, so that is good. Now I am trying to clean up so that I can do the next one which is where I am running into trouble.
It appears that during the restore it created a number of AQ tables such as AQ$_PRINT_Q_TAB_L so when I try to drop the TABLESPACE I get the error:
DROP TABLESPACE TBLE INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-24005: Inappropriate utilities used to perform DDL on AQ table
DBO.AQ$_PRINT_Q_TAB_L
Now I can see from the documentation that I can't use DROP TABLE and I have confirmed that attempting it produces the same Inappropriate utilities error as above. But when I try the appropriate commands I get the following:
DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => ‘AQ$_PRINT_Q_TAB_L’);
SP2-0734: unknown command beginning “DBMS_AQADM…” - rest of line ignored.
It appears to me the the 21c XE Express Edition does not include Advanced Queuing utilities, which is fine, but in that case how can I go about dropping these tables so that I can clear out this TABLESPACE.
Again, as mentioned, this data has already been converted to MS-SQL so there is no chance of corruption etc. I just need it gone by any means necessary so that I can get setup for a new one. If I have to I will destroy this VM and start from scratch, but I prefer to learn how to handle this properly to save myself time in the future.