Migrating data to24X7 website w/o interrupt

[rdann]

Help! We need any suggestions for migrating data into a 24X7 web production database without any interrupt to the users. Currently, we migrate only 3-4 tables at 3am, our migrate
method is simply a truncate and copy statement which is automated. Our problems lies in the fact that users on the website at the time of migration get a blank page! Is there anything we can do with triggers, packages, procedures or just downright trickiness, that will make our migrations transparent to the users? Thank you!

[jgmagnus]

How about haveing a Parallel server?

[pwoneill]

Hrm, do you know why the users get a blank page? Is it a blank page or a "document contains no data" error? Is it because the page is trying to use new data and it's not there yet? Is the I/O from the copy statement just causing the page to slow down? Does the page not finish loading for some reason, leaving some </table> tags missing?

Maybe whatever you're doing is locking some tables so the pages can't access it and the queries hang while waiting for the process to be done. Are your pages pl/sql or some other? (perl, jsp, php, etc).

What do you mean by truncate and copy? :)