Re: help! create table as select...

From: <michael_bialik_at_my-deja.com>
Date: Wed, 24 Nov 1999 21:26:34 GMT
Message-ID: <81hl65$dvo$1@nnrp1.deja.com>

Hi.

 Try
  CREATE TABLE new_table

     TABLESPACE my_tablespace
     STORAGE(
     INITIAL 500K
     NEXT 500

 ) AS SELECT * FROM my_table;

 Sorry - I couldn't check it now myself.

 HTH. Michael.

In article <81h5lk$240$1_at_nnrp1.deja.com>,   kal121_at_yahoo.com wrote:
> What is the syntax to specify a tablespace and storage clause in
> a "CREATE TABLE AS SELECT ..." statement?
>
> eg)
>
> CREATE TABLE AS SELECT * FROM my_table
> TABLESPACE my_tablespace
> STORAGE(
> INITIAL 500K
> NEXT 500
> );
>
> for some reason, the above syntax does not work, although this is the
> correct way to specify tablespace and storage in a regular create
table
> statement.
>
> Thanks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 24 1999 - 15:26:34 CST