Re: help! create table as select...

From: <cheongwaikit_at_my-deja.com>
Date: Wed, 24 Nov 1999 02:45:04 GMT
Message-ID: <81fjfg$uus$1@nnrp1.deja.com>

shouldn't it be,

     create table <new table name> storage (initial 1k next 1k)
     tablespace <tablespace name>
     as select * from <my_table>;

In article <81fghb$sum$1_at_nnrp1.deja.com>, kal121_at_yahoo.com wrote:
> How come this doesn't work? I need to be able to specify the
tablespace
> and storage parameters in the "create table as select..." statement.
>
> Thanks!
>
> CREATE TABLE AS SELECT * FROM my_table
> TABLESPACE my_tablespace
> STORAGE(
> INITIAL 1K
> NEXT 1K
> );
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 23 1999 - 20:45:04 CST