-
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}
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|