Re: Create new table as select Help PLease!!!!

create table ...
tablespace user_data
as select * from ... etc

and please post typical sql questions in .server only.

Hth,

Sybrand Bakker, Oracle DBA

"Scott Hahn" <scott_hahn_at_hotmail.com> wrote in message news:f9OE5.77$%J6.7640_at_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 - 23:37:47 CDT