Remover a tablespace EXAMPLE

Se ocorrer o problema abaixo:

SQL> drop tablespace example including contents and datafiles;
drop tablespace example including contents and datafiles
*
ERRO na linha 1:
ORA-00604: ocorreu um erro no nÝvel 1 SQL recursivo
ORA-24005: deve utilizar DBMS_AQADM.DROP_QUEUE_TABLE para eliminar tabelas em
fila

Faça os comandos abaixo e tera sucesso !

sql> conn / as sysdba

select name, queue_table from dba_queues;



conn ix/ix
execute DBMS_AQADM.DROP_QUEUE_TABLE('ix.AQ$_ORDERS_QUEUETABLE_G',true);
execute DBMS_AQADM.DROP_QUEUE_TABLE('ix.AQ$_ORDERS_QUEUETABLE_H',true);
execute DBMS_AQADM.DROP_QUEUE_TABLE('ix.AQ$_ORDERS_QUEUETABLE_I',true);
execute DBMS_AQADM.DROP_QUEUE_TABLE('ix.AQ$_ORDERS_QUEUETABLE_T',true);

execute DBMS_AQADM.DROP_QUEUE_TABLE('ix.AQ$_ORDERS_QUEUETABLE_S',true);
execute DBMS_AQADM.DROP_QUEUE_TABLE('ix.ORDERS_QUEUETABLE',true);

execute DBMS_AQADM.DROP_QUEUE_TABLE('ix.AQ$_STREAMS_QUEUE_TABLE_C',true);
alter table ix.AQ$_STREAMS_QUEUE_TABLE_C rename to curto;
execute DBMS_AQADM.DROP_QUEUE_TABLE('ix.CURTO',true);

execute DBMS_AQADM.DROP_QUEUE_TABLE('ix.AQ$_STREAMS_QUEUE_TABLE_G',true);

execute DBMS_AQADM.DROP_QUEUE_TABLE('ix.AQ$_STREAMS_QUEUE_TABLE_H',true);
execute DBMS_AQADM.DROP_QUEUE_TABLE('ix.AQ$_STREAMS_QUEUE_TABLE_I',true);
execute DBMS_AQADM.DROP_QUEUE_TABLE('ix.AQ$_STREAMS_QUEUE_TABLE_T',true);
execute DBMS_AQADM.DROP_QUEUE_TABLE('ix.STREAMS_QUEUE_TABLE',true);

conn sys/welcome1 as sysdba

drop user oe cascade;
drop user sh cascade;
drop user ix cascade;
drop user bi cascade;
drop user pm cascade;
drop user hr cascade;


alter database default tablespace system;

drop tablespace USERS including contents and datafiles;
drop tablespace example including contents and datafiles;
alter database default tablespace users;


exit;