Hi

quick n dirty answer to you...on how to resize :-D

export the database with compress=y

import the database ..


then you can resize your datafile..i suspect you have non system database objects in the system tablespace.

ahh..i hope your database is small enough to do export import..

regards
Hrishy