Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Copy Long raw from table to table issue
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 - 11:26:39 CDT