Need to clean up my Oracle database
Unless you have a storage snapshot, restore point or backup of the database before the testing started, TRUNCATE is a way to go. You may need to disable FK constraints for that. Another way is to run expdp with CONTENT=METADATA_ONLY, drop the schema, and import the metadata back.