Thanks John,

I know I can "DROP TABLESPACE INCLUDING CONTENTS" but we are going to run Oracle Parallel Server soon so I'm not sure if this is a wis edecision. The recovery issue is another thing and I've not done it before.

Is it possible to claim back the space taken by the empty tables in these tablespaces? Please advice.

Ac