oracle db drop all tables code example Example: oracle sql drop table DROP TABLE my_table; -- To 'really' free space DROP TABLE my_table PURGE;