Re: easy question...i think

Someone <answers_at_erols.com> writes:

>creating the new tables can be done easily without impacting anything
>running. Test the create view DDL before your cutover so you know it
>works without a glitch (including any privileges associated with it).
>At the point of cut-over, run a script that will
 

>1. rename the table it to another name (ie MyTable_Old)
>2. create the view (i assume the view uses the same name as the old
>table)
>3. backup the old table via table export
>4. drop the old table.

By creating the view right after creating the new tables, creating a public synonym for the view, then renaming the original table etc., outage time can be eliminated. Received on Tue Sep 16 1997 - 00:00:00 CDT