Thanks sir for your reply, I have tried EM but the character set is different for 10g and 11g so it got rejected. I am thinking about using Network Links but this would only satisfy the downtime if the tablespaces are less in size. But how about situations like loading data from warehouse to data marts?. Need your expertise in this situation.

Thanks