I have a question that I have not been able to find the answer for in combing through the documentation so I am asking it here in hopes someone can point me in the right direction.
Our shop is getting ready to do an upgrade of a very large database and we are hoping for minimal downtime (of course). I was considering using impdp with NETWORK_LINK to do a full import into the new instance.
My question is: Do we need to stop the users from performing any transactions on the source database during the entire duration of the import in order to get a consistent import? Is there a benefit to setting a CONSISTENT parameter in conjunction with a NETWORK_LINK import, and if so what is the limit on the time it can be consistent to? I am secretly hoping that impdp can keep the transactions consistent all the way up through the completion of the import, but I fear that is not the case
I am open to suggestions - thanks
Wylie Merritt
DBA - faa.gov