creating table using as select and tablespace
Hello,
I want to create a table using this statement but I can an error:
create table new_table as
select * from old_table
tablespace new_tablespace;
Why does the clause 'tablespace' creates an error.
I want to create the new_table on a different tablespace. I can change my default tablespace but I rather not. I can move the new_table to a different tablespace but I rather not. I just want to create the new_table in a different tablespace in One Shoot as the statement above but I get an error. Can you some suggest a way. Thank you.
Paul