From: "Sybrand Bakker" <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools
Subject: Re: Create new table as select Help PLease!!!!
Date: Wed, 11 Oct 2000 06:37:47 +0200
Message-ID: <971240009.13146.0.pluto.d4ee154e@news.demon.nl>
References: <f9OE5.77$%J6.7640@news1.news.adelphia.net>
NNTP-Posting-Host: sybrandb.demon.nl
X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78
X-Trace: news.demon.nl 971240009 pluto:13146 NO-IDENT sybrandb.demon.nl:212.238.21.78
X-Complaints-To: abuse@nl.demon.net
X-Newsreader: Microsoft Outlook Express 5.00.3018.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300
Lines: 42


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@hotmail.com> wrote in message
news: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@hotmail.com
>
>
>
>