Hi Gandolf,

Thanks for your reply.

As i said in my post, TTS is not a feasable option in my case because both schemas Y & Z are sharing the same tablespace and at a given time I need to refresh either Y or Z.

Thanks,