Re: use copy command with error ORA--4192986
From: NOVA <nova1427_at_gmail.com>
Date: Mon, 19 Jan 2009 04:49:51 -0800 (PST)
Message-ID: <a5a06c3e-e675-49c3-982c-96367f8aa0e1_at_f40g2000pri.googlegroups.com>
On Jan 19, 3:14 pm, gazzag <gar..._at_jamms.org> wrote:
> On 19 Jan, 11:19, NOVA <nova1..._at_gmail.com> wrote:
>
>
>
>
>
> > dear all,
>
> > I'm try to make copy from other database to local database by copy
> > command but I got error as the following:
>
> > SQL>
> > copy from user/password_at_xxxx -
> > insert tablename -
> > using SELECT 's','f' FROM dual ;
>
> > Array fetch/bind size is 15. (arraysize is 15)
> > Will commit when done. (copycommit is 0)
> > Maximum long size is 80. (long is 80)
>
> > ERROR:
> > ORA--4192986: Message -4192986 not found; product=RDBMS; facility=ORA
>
> > can you help please.
>
> > thx
>
> Could you please supply:
>
> 1. Oracle version.
> 2. An actual screen-scrape (copy/paste) of a session that displays
> the behaviour in question.
> 3. The relevant section of the alert log with the errors involved.
>
> ORA-4192986 is not an Oracle error that I can find.
>
> HTH
>
> -g- Hide quoted text -
>
> - Show quoted text -
Date: Mon, 19 Jan 2009 04:49:51 -0800 (PST)
Message-ID: <a5a06c3e-e675-49c3-982c-96367f8aa0e1_at_f40g2000pri.googlegroups.com>
On Jan 19, 3:14 pm, gazzag <gar..._at_jamms.org> wrote:
> On 19 Jan, 11:19, NOVA <nova1..._at_gmail.com> wrote:
>
>
>
>
>
> > dear all,
>
> > I'm try to make copy from other database to local database by copy
> > command but I got error as the following:
>
> > SQL>
> > copy from user/password_at_xxxx -
> > insert tablename -
> > using SELECT 's','f' FROM dual ;
>
> > Array fetch/bind size is 15. (arraysize is 15)
> > Will commit when done. (copycommit is 0)
> > Maximum long size is 80. (long is 80)
>
> > ERROR:
> > ORA--4192986: Message -4192986 not found; product=RDBMS; facility=ORA
>
> > can you help please.
>
> > thx
>
> Could you please supply:
>
> 1. Oracle version.
> 2. An actual screen-scrape (copy/paste) of a session that displays
> the behaviour in question.
> 3. The relevant section of the alert log with the errors involved.
>
> ORA-4192986 is not an Oracle error that I can find.
>
> HTH
>
> -g- Hide quoted text -
>
> - Show quoted text -
thanks for replay
i fixed the problem
I change Oracle version from 8i to 9i and its solved.
thx Received on Mon Jan 19 2009 - 06:49:51 CST