Hi there,

Here is the senario ...

I have a schema X in production (nearly 600 tables some of them are composite partitioned and 960 indexes) need to refresh in to schema Y and schema Z in SIT database. Please note that schema Y & Z will have same set of objects from schema X and both Y & Z are sharing same table space.

Schema Y is used for SIT and Z is for training.

Currently I am using traditional expdp / impdp process to refresh. This process is taking close to 8 hours to import data and nearly two days to create all the indexes. I am exploring the other options to make this process faster.

I believe TTS & RMAN methods are not possible because Y and Z are sharing same tablespace.

Your expertise ideas are much appreciated.

Thanks,