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 -> Re: Copy Long raw from table to table issue

Re: Copy Long raw from table to table issue

From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Thu, 17 Apr 2003 01:59:59 GMT
Message-ID: <zUnna.481192$L1.139760@sccrnsc02>


Sorry I meant array size

--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Prakash" <venkatprakash_at_hotmail.com> wrote in message
news:78b3b5e2.0304160826.18c1a4be_at_posting.google.com...

> Hi
>
> How do you set fetch size 1? I tried and its coming back saying
> "unknown command set fetchsize".
>
> Any help?
>
> Thanks
>
>
> "Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message
news:<kyJma.217203$Zo.40978_at_sccrnsc03>...
> > try fetch size 1 and array size 1
> > Jim
> >
> > --
> > Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
> > with family. Remove the negative part, keep the minus sign. You can
figure
> > it out.
> > "Prakash" <venkatprakash_at_hotmail.com> wrote in message
> > news:78b3b5e2.0304140925.5275b004_at_posting.google.com...
> > > Hi
> > >
> > > I am trying to copy data from one table to another. Source has one
> > > Long Raw column. There are about million rows in source table. And I
> > > am using Oracle 8.1.5. Whenever I execute the copy command, I get the
> > > following error message: Can someone help me?
> > >
> > >
> > > SQL> set long 64000000
> > > SQL> set copycommit 1
> > > SQL> set arraysize 100
> > > SQL> COPY to test/test_at_testfix CREATE resume_bkup1 using select * from
> > > resume;
> > >
> > > Array fetch/bind size is 100. (arraysize is 100)
> > > Will commit after every array bind. (copycommit is 1)
> > > Maximum long size is 64000000. (long is 64000000)
> > >
> > > ERROR:
> > > ORA-01084: invalid argument in OCI call
> > >
> > > SQL>
> > >
> > > Thanks
> > >
> > > V Prakash
Received on Wed Apr 16 2003 - 20:59:59 CDT

Original text of this message

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