I have a tablespace size 4GB . This tablespace contains only one rollback segment ,no tables etc. Currently no transactions pending for a week . I just dropped that tablespace and recreated , still it occupied 4gb . How to clean that 4GB rollback information ..And it the temporary table space is filled up with 3 GB . How to clean it . Currently no user's connected ,no transactions ..
Raghu