Re: create table

From: Regina Harter <rharter_at_emc-inc.com>
Date: Tue, 07 Nov 2000 10:41:50 -0800
Message-Id: <10673.121338@fatcity.com>

At 09:40 AM 11/7/00 -0800, you wrote:

>Hi gurus,
>
>I have no problem with this :
> create table table1 (a number) tablespace tools
>
>But I can't do this :
> create table table2 as (select * from table1) tablespace tools
>
>What is the solution

The solution is:

create table table2 tablespace tools as (select * from table1)

>TIA
>
>-----------------
>Luc Demanche
>CETELEM
>T=E9l.: 01-46-39-14-49
>Fax : 01-46-39-59-88
Received on Tue Nov 07 2000 - 12:41:50 CST