Q: Table Creation and Long Variables

From: <mhalpeth_at_my-dejanews.com>
Date: Mon, 03 Aug 1998 16:09:10 GMT
Message-ID: <6q4nb6$ag7$1@nnrp1.dejanews.com>

Hi SQL Masters !!

Is there any way to create a table from a table which has a long variable alongwith the data as it is ....

eg :
Table 'ora_tab_199801'

---

one number,
two varchar2(10),
three date,
four long

Now can its not possible to create a table by issuing a command ... create table ora_tab
as
select * from ora_tab_199801
where .....

it displays the error : ORA-00997: illegal use of LONG datatype

is there any way of getting around this ??

cheers !

Mahesh
Pls cc : mashy_at_null.net , TA.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 03 1998 - 11:09:10 CDT