creating a table from a table onto a non default tablespace

Hi,

I'm trying to find how to create a table from a table on a non default tablespace. Is this possible?

For instance I can do:

create table table1 (
 a number(1)
) tablespace tablespace1;

and I can do

create table table1 as select a from table2;

but I can't figure out how to combine these two.. I'm trying

create table table1
  as select a from table2 tablespace tablespace1

and I'm getting "SQL command not properly ended." Any suggestions?

Thanks!

paul Received on Tue Aug 10 1999 - 11:58:29 CDT