Re: create table

From: ARUN K C <arun_k_c_at_hotmail.com>
Date: Tue, 07 Nov 2000 18:51:30 GMT
Message-Id: <10673.121339@fatcity.com>

it should be
create table table2
storage()
tablespace tools
as select * from table1;

>From: "DEMANCHE Luc (Cetelem)" <luc.demanche_at_cetelem.fr>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: create table
>Date: Tue, 07 Nov 2000 09:40:32 -0800
>
>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
>
>TIA
>
>-----------------
>Luc Demanche
>CETELEM
>Tél.: 01-46-39-14-49
>Fax : 01-46-39-59-88
>

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at Received on Tue Nov 07 2000 - 12:51:30 CST