OK, so I tried the resize command but it wont let me get rid of any considerable space, just a little amount.

I dont think I can get rid of the entire tablespace because the tables I created are under the SYSTEM tablespace and getting rid of the SYSTEM tablespace might not be a good idea.

I even tried getting rid of the entire table that I tried loading the 450M data into, and even that didnt help.

What else can I try?