Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> help! create table as select...
What is the syntax to specify a tablespace and storage clause in
a "CREATE TABLE AS SELECT ..." statement?
eg)
CREATE TABLE AS SELECT * FROM my_table
TABLESPACE my_tablespace
STORAGE(
INITIAL 500K
NEXT 500
);
for some reason, the above syntax does not work, although this is the correct way to specify tablespace and storage in a regular create table statement.
Thanks
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Nov 24 1999 - 11:01:44 CST