quick refresh

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,

adding ....

schema Y & Z refresh will not happen same time. It should be different based on the request from the respective teams.

Thanks,

Have you thought about transportable table spaces?

http://www.oracle.com/pls/db102/sear...&format=ranked

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,

Quote:

---

Originally Posted by vnktummala

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,

---

Well...separate them!
:rolleyes: