Create new table as select Help PLease!!!!

From: Scott Hahn <scott_hahn_at_hotmail.com>
Date: Wed, 11 Oct 2000 00:05:31 GMT
Message-ID: <f9OE5.77$%J6.7640@news1.news.adelphia.net>

Oracle 7.3.4

I am trying to create a new table based on a select clause of another table and am having problems. It always creates the table in the system tablespace even though I have changed the users default tablespace to user_data ? I tried adding the tablespace user_data clause to the end of the statement but get a syntax error. What am I doing wrong? Any and all hep appreciatted.

command

create table userid.pm_section_lg_arch as select *

from userid.pm_section_lg where entry_timestamp

<= to_date('15-AUG-00 14:46:27','DD-MON-YY HH24:MI:SS') tablespace user_data;

Thanks

scott_hahn_at_hotmail.com Received on Tue Oct 10 2000 - 19:05:31 CDT