I'm working with a test database on my laptop and I had to abort a couple of large inserts and index builds. A few of my DBF files are very large. In particular,
TEMP01.DBF - 8Gigs+
UNDOTBS01.DBF - 5.5Gigs
USERS01.DBF - 3.7Gigs
I don't have exactly which tables and indexes are in which tablespaces, but I know I'm not using that much space. Is there any way to reduce the sizes of those files?