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

hi scott,

the physical storage parameters preceed the AS key word in create table as statement. try the following:

create table emp1
tablespace project1
pctfree 40
storage (initial 2)
AS (select * from emp)

it works on my 8i, but given the syntax it *should* work on your 7.x as well, well that's what i hope;)

HTH ATTA In article <f9OE5.77$%J6.7640_at_news1.news.adelphia.net>,   "Scott Hahn" <scott_hahn_at_hotmail.com> wrote:
> 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
>
>

--

getting the meanin' of data...


Sent via Deja.com http://www.deja.com/
Before you buy.