Hi Ales

*************************************************
imp user/pwd full=y indexfile=schema.sql

In the schema.sql you'll see the create statements for all objects with tablespace names
*************************************************
where to give this command, I think it will start importing data. How can i know the tablespace names and size from export.dmp file ??

Any other way.....? any other suggestions ??