Log into your database as sys using sqlplus and run the following file. It will let you know the high water mark of each tablespace and the largest free extent.This should help you to decide if you can shrink your database.
But before you start shrinking things, you try to do some basic reading to get a better understanding of space management in Oracle.
Reply With Quote