Jmac,

Here's something you can try to get rid of the old undo tablespace.

In your init.ora you can comment out your UNDO_TABLESPACE parameter. The instance will start but it will use the system rollback segement. If you do this your undo management will not be used. This "should" give you the ablility to clean up your tablespaces.


I got this info from the Oracle9i New features for Admins- page 14-7 if you want to look it up.