Create new table as select Help PLease!!!!

[Quoted] Oracle 7.3.4

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

command

[Quoted] [Quoted] 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 Wed Oct 11 2000 - 02:05:31 CEST