select 'drop table '|| table_name ||';' from dba_tables; select 'drop index '|| index_name || ';' from dba_indexes;