The reason I would like the easy way instead of creating a separate
table first (CREATE TABLE and then INSERT INTO ) is because the table
is from a third party tool (SAP ) has probably more than a hundred
cryptic-named columns (fields) of different types !!!
nilanjan_sarkar_at_hotmail.com (nilanjan) wrote in message news:<6c8b1f5.0207191044.591ffe7b_at_posting.google.com>...
> Oracle Guru's :
>
> Is there a way to CREATE a PARTITIONED table from a non-partitioned
> one using the CREATE TABLE ..AS SELECT.. syntax ? I couldnt find it in
> the manuals..
>
> ( the few tables in question are about 20 Gigs in size each )
Received on Fri Jul 19 2002 - 17:06:11 CDT
