DROP ALL TABLES AND SEQUENCES IN THE ORACLE

List all of tables and sequences

This script will garther data and generate a script which use to drop all of tables and sequences, please look at in the following:

SQL> select 'drop table ' || table_name || ';' from user_tables;
SQL> select 'drop sequence ' || sequence_name || ';' from user_sequences;

NOTE:: Be careful please check your expectation beforce implementation.

Thank you for your reading. Done!