Re: help! create table as select...

Try

CREATE TABLE xyz
TABLESPACE my_tablespace
STORAGE(
INITIAL 1K
NEXT 1K)
UNRECOVERABLE (or other options)
AS SELECT * FROM my_table

kal121_at_yahoo.com wrote in message <81fghb$sum$1_at_nnrp1.deja.com>...
>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
>>);
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Nov 23 1999 - 20:38:47 CST