help! create table as select...

How come this doesn't work? I need to be able to specify the tablespace and storage parameters in the "create table as select..." statement.

Thanks!

CREATE TABLE AS SELECT * FROM my_table
TABLESPACE my_tablespace
STORAGE(
INITIAL 1K
NEXT 1K
);

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 23 1999 - 19:54:52 CST