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.
CREATE TABLE {table1} STORAGE clause for table1 AS {sub Query of table2}
Forum Rules
Bookmarks