-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
adding ....
schema Y & Z refresh will not happen same time. It should be different based on the request from the respective teams.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Divorce is the answer!
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!
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|