Re: How to insert long raw column

From: doknjas <doknjas_at_netpointer.com>
Date: 1998/02/24
Message-ID: <6cti3h$rln$1@newsfeed.smartt.com>#1/1

I believe Oracle has a problem with this when dealing with long fields. Perhaps, you could do an export of tab_2 and import into tab_1 to get around this problem.

Victoria

"gcma" <gcma_at_sprynet.com> wrote:

>We need to insert into a table with a long raw coloumn from another table
>also with a long raw column.
>The following statement does not work:

>insert into tab_1 as select * from tab_2;

>Any one knows how?

>Thanks in advanced.
Received on Tue Feb 24 1998 - 00:00:00 CST