Originally posted by st2003
All these take a lot of time.

DB link and 200GB ?

Thanks, ST2003
You could do multiple exports and import them in parallel with importing indexes. Then create all of you indexes in parallel.

It seems that you want the databases to be insync before you do your daily load, then do the daily load on the new system. Because, why would you load the current day and then migrate it. In any event you may need some downtime.