Re: Fastest way to create new table based on a view?

From: John Bracken <Johnb_at_jbracken.demon.co.uk>
Date: 1996/01/31
Message-ID: <823101421.9750_at_jbracken.demon.co.uk>#1/1

KERRG_at_TIMKEN.COM (Glenn Kerr) wrote:

>In article <1771AD275S86.PGSCHMID_at_bcsc02.gov.bc.ca>
>PGSCHMID_at_bcsc02.gov.bc.ca writes:
>
>>
>>I'd like to create a new table based on a view which contains a join
>>of several tables. What is the fastest way to perform this without
>>writing the view rows to an OS file and using SQL*Loader to load the
>>new table?
>>
>><snip>
>

How about:

   create table NNNNN parallel (degree NNN) tablespace NNNNN unrecoverable as select * from NNNNNNN_VIEW /

---

John Bracken -- 'Gooden day, big-feller mine host! Trois Liverpool, UK beers pour favour avec us, silver plate' --

• johnb_at_jbracken.demon.co.uk ..or.. jbracken_at_uk.oracle.com ======

Received on Wed Jan 31 1996 - 00:00:00 CET