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

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?
>
>So far the SQL*Net COPY seems to be fastest. The new table
>will contain approx 500,000 rows. We are running a read-only Data
>Warehouse environment so I don't care if the new table is recoverable.
>
>Thanks.
>Petr Schmidt
>pgschmid_at_bcsc02.gov.bc.ca

Have you tried:

        CREATE TABLE New_Tab
             AS SELECT * FROM View_Name;

-- 
Clive Bostock