sweet!
Andy Thompson <AndrewT_at_MedImpact.com> wrote in message
news:383b50c4_at_news1.jps.net...
> 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 Wed Nov 24 1999 - 12:16:13 CST
