Drop Table Sequence Oracle

Abaixo os comandos utilizados para limpar o BD oracle.

SELECT 'DROP TABLE ' || TABLE_NAME || ';' || ' COMMIT;'
   FROM ALL_SEQUE
   WHERE TABLESPACE_NAME = 'FIS175'
     AND TABLE_NAME IN(SELECT TABLE_NAME
                       FROM ALL_TABLES
                       WHERE TABLESPACE_NAME = 'FIS175')

select   DISTINCT 'DROP SEQUENCE '||SEQUENCE_OWNER||'."'||SEQUENCE_NAME||'";'
from     dba_sequences
where    sequence_owner = upper('FIS175')

REF:
https://www.dirceuresende.com/blog/apagando-todos-os-objetos-de-um-owner-no-oracle-database/