On Mon, Nov 24, 2008 at 5:12 AM, Mercadante, Thomas F (LABOR) < Thomas.Mercadante@xxxxxxxxxxxxxxxxx> wrote: > Create the MV's on the other tables. Refresh them at a schedule that is > convenient for you. It might be once a day or every hour. > One thing to add to that: you should probably build the tables and create the MV's on prebuilt tables. That way when you drop the MV on the target, the table remains.