Re: How to replace the "Copy from" command?
Date: Wed, 23 Jan 2008 07:14:30 -0800 (PST)
Message-ID: <04ef8c83-e335-4962-bbb4-2e92012677cb@j20g2000hsi.googlegroups.com>
On Jan 23, 8:54 am, nionio_usa <antonio.bote..._at_arc-intl.com> wrote:
> On 23 jan, 14:58, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>
>
>
>
>
> > On Jan 23, 7:30 am, nionio_usa <antonio.bote..._at_arc-intl.com> wrote:
>
> > > Hi All,
> > > Actually using 8i and 9i version of Oracle, we are migrating to the
> > > 10g version.
> > > We used to use the "copy from" syntax to copy data from DB1 to DB2 via
> > > DBLINK.
>
> > > Looks like this "copy from" does not work on 10g.
> > > I'd like to know how to replace that command?
>
> > > Thanks in advance.
> > > --
> > > dblink defined between DB1 and DB2.
>
> > > on DB1
> > > truncate table table1;
> > > set arraysize 1000
> > > set copycommit 1
> > > copy from user/pass_at_DB2 to user/pass_at_DB1 -
> > > insert table1 using select * from table1;
> > > quit
>
> > The COPY command still exists in 10.2.0.3; what leads you to believe
> > it isn't working? What error messages do you see,. if any? I had no
> > problems getting the copy command to work from 10.2.0.3.
>
> > Provide more detail; what you've provided thus far is insufficient to
> > determine why this isn't working for you.
>
> > And please DO NOT post a question more than once. It doesn't get you
> > any faster response, and may get you ignored.
>
> > David Fitzjarrell- Masquer le texte des messages précédents -
>
> > - Afficher le texte des messages précédents -
>
> I'm getting that error:
> unknown command "copy" - rest of line ignored.
>
> And I DO NOT know what happen to get the initial message posted 3
> times. Sorry- Hide quoted text -
>
> - Show quoted text -
Again, the COPY command exists in 10.2.0.3, and using your commands (modified, of course, to reflect my environment and databases):
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jan 23 09:04:33 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> connect wiffle/waffle_at_wallawalla
Connected.
SQL> truncate table doodlewop_finagly;
Table truncated.
SQL> set arraysize 1000 SQL> set copycommit 1 SQL> copy from dingle/berry_at_berrybush to wiffle/waffle_at_wallawalla -
> insert doodlewop_finagly using select * from doodlewop_finagly;
Array fetch/bind size is 1000. (arraysize is 1000) Will commit after every array bind. (copycommit is 1) Maximum long size is 80. (long is 80)
66550 rows selected from dingle_at_berrybush. 66550 rows inserted into DOODLEWOP_FINAGLY. 66550 rows committed into DOODLEWOP_FINAGLY at wiffle_at_wallawalla.
SQL> Please run your script and spool the output so you can post it here. It's the only way anyone can determine what the issue might be.
David Fitzjarrell Received on Wed Jan 23 2008 - 09:14:30 CST