Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help! create table as select...
set your default tablespace to be the tablespace you want the table created
it..
alter the storage clause after if need be
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
>TABLESPACE my_tablespace
>STORAGE(
>INITIAL 1K
>NEXT 1K
>);
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Nov 23 1999 - 20:56:01 CST