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?
>
><snip>
 

Why not simply Create table new_table as select * from view; in sql*plus. I'm not sure how long this will take. Also, you might need some storage parameters on the table depending on your defaults.  

Glenn Kerr
kerrg_at_timken.com Received on Mon Jan 29 1996 - 00:00:00 CET