Originally posted by Indy
Thanks Guys for your quick response.

Pando - Is there any SQL I can use to interogate the database to find out exactly how much the tablespace needs to be?

ggnanaraj - Thanks for the tip. Sounds very useful if I ever want to import a few tables. Can't use it this time as I have 700+ tables.

select owner, tablespace_name, sum(bytes/(1024*1024))
from dba_segments
group by owner, tablespace_name;