Re: easy question...i think

From: Michael Bierenfeld <michael.bierenfeld_at_ibsgmbh.de>
Date: 1997/09/16
Message-ID: <341E5213.6CEBBE32@ibsgmbh.de>#1/1

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.

create table <table1> as select col1, col2 .. from source table; dito table2.

Create your view now. There is no need to shutdown the database or something like this. You might want to use the create table command instead (with storage claus) and then copy the data.

Regards

Michael Received on Tue Sep 16 1997 - 00:00:00 CDT