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!