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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Inserting data from a long column across a dblink

Re: Inserting data from a long column across a dblink

From: Happy <allan_at_livvy80.freeserve.co.uk>
Date: Thu, 1 Feb 2001 22:08:15 -0000
Message-ID: <95cmv3$gpt$1@newsg1.svr.pol.co.uk>

I'd use the COPY command, and set long to a very high number.

Cheers
Allan

<gamebuddah_at_my-deja.com> wrote in message news:95cfgn$8h5$1_at_nnrp1.deja.com...
> I have a situation where I need to insert information into a local
> table based on the join of two tables on a remote machine. One of the
> columns in the select is a long column. Is there any way to work
> around the problems with selecting longs across a database link?
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Feb 01 2001 - 16:08:15 CST

Original text of this message

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