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.

Examine the SQL Language Reference Manual on the CREATE TABLE command:

CREATE TABLE copy1 AS SELECT * FROM origTable; CREATE TABLE copy2 AS SELECT * FROM origTable;

• TRW -- ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | Tim Witort || He is not silent. He is not | | trwATmedicalertDOTorg || whispering. We are not quiet | | || we are not listening. | | Pin: TZ, only one :^( || - Out of the Grey | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||