Re: Create Partitioned Table

From: Steve <smontgomerie_at_hotmail.com>
Date: 19 Jul 2002 18:01:35 -0700
Message-ID: <156709aa.0207191701.2d8649ad@posting.google.com>

check the concepts guide, you can merge a non partitioned table into a partioned table, the syntx is not ctas but rather a an alter partition statement I believe

steve

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 - 20:01:35 CDT