Re: easy question...i think

Thank You Both for your response.
Satar Naghshineh

Nathan D. Hughes wrote:
>
> 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 Wed Sep 17 1997 - 00:00:00 CDT