Whenever I try to create a new table based on a
create table table2 as (select * from table1) tablespace data01
it gives me an error when I try and specify a tablespace
ORA-00933: SQL command not properly ended. Does anyone know a way of specifying a tablespace in this statement.