Re: easy question...i think

Satar Naghshineh wrote:

> 15-SEPT-97
>
> Oracle 7.2.3
> sun OS 2.5.1
>
> Hi,
> I want to transfer current table data into two new tables, then create
> a
> view based on the two new tables. I would I go about doing that in 1
> 24/7 shop? Thanks in advance,
> Satar Naghshineh
> SatarNag_at_worldsite.com
>
> P.S. I will post more Oracle Worldwide Support's FAQs as soon as I can
>
> find the time.

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.

The total "outage" time should not be more than a minute...if everything works. Be sure to advise affected users that you are doing this change and that while you do not expect any problems, you are making a change. It is better to forewarn them. Received on Tue Sep 16 1997 - 00:00:00 CDT