Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Table Creation with a Long Variable

Table Creation with a Long Variable

From: <mhalpeth_at_my-dejanews.com>
Date: Mon, 03 Aug 1998 16:14:51 GMT
Message-ID: <6q4nlr$as9$1@nnrp1.dejanews.com> 





Hiya !



Is there a way to create a table from a table which has a long variable ..as :



Create table temp2


as


select * from temp1


where  col1 .....



where the temp1 table has a long variable ... !! It displays the error
message : ORA-00997: illegal use of LONG datatype



Any ways to get around this ...!!



Cheers !



Mahesh


Pls Cc : to 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:14:51 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US