DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: quick refresh

  1. #1
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865

    Question 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.

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Have you thought about transportable table spaces?

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

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool Divorce is the answer!

    Quote Originally Posted by vnktummala View Post
    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
  •  


Click Here to Expand Forum to Full Width