From: "Scott Hahn" <scott_hahn@hotmail.com>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools
Subject: Create new table as select Help PLease!!!!
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <f9OE5.77$%J6.7640@news1.news.adelphia.net>
Date: Wed, 11 Oct 2000 00:05:31 GMT
NNTP-Posting-Host: 24.51.86.97
X-Complaints-To: abuse@adelphia.net
X-Trace: news1.news.adelphia.net 971222731 24.51.86.97 (Tue, 10 Oct 2000 20:05:31 EDT)
NNTP-Posting-Date: Tue, 10 Oct 2000 20:05:31 EDT


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