Re: copying table data with "long" rows

From: michael ngong <mngong_at_yahoo.com>
Date: 6 May 2002 09:02:48 -0700
Message-ID: <ecf365d5.0205060802.14215118@posting.google.com>

"Stephan Bressler" <stephan.bressler_at_pdb.sbs.de> wrote in message news:<ab5ekf$oj7$1_at_news.mch.sbs.de>...
> Hi,
>
> I need to do something like
> insert into tab_a select * from tab_b where ...
>
> Unfortunately, both tables contain a column of type 'long'.
>
> Is there a short workaround, e.g. PL/SQL?
>
> TIA
> Stephan

I normally go around that by exporting an importing Michael Tubuo Ngong ( Sr DBA) Received on Mon May 06 2002 - 11:02:48 CDT