How do I delete a tablespace

[davey23uk]

you need to offline drop that datafile, then drop the tablespace

and no you cant recreate things, your data is gone