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.