Re: Use MV to convert 9i to 10g

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 24 Nov 2008 14:56:10 -0800
Message-ID: <bf46380811241456y565df165v4b4ab1a458713edf@mail.gmail.com>

On Mon, Nov 24, 2008 at 5:12 AM, Mercadante, Thomas F (LABOR) < Thomas.Mercadante_at_labor.state.ny.us> 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.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 24 2008 - 16:56:10 CST

This message: [ Message body ]
Next message: Ray Stell: "ADR file archive tools"
Previous message: Finn Jorgensen: "Re: Method for migrating schema from PROD to DEV"
In reply to: Mercadante, Thomas F (LABOR): "RE: Use MV to convert 9i to 10g"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message