Re: use copy command with error ORA--4192986
From: gazzag <gareth_at_jamms.org>
Date: Mon, 19 Jan 2009 04:14:19 -0800 (PST)
Message-ID: <64bce1a2-c71b-4c10-a9ee-3aa47d71574b_at_p23g2000prp.googlegroups.com>
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
Date: Mon, 19 Jan 2009 04:14:19 -0800 (PST)
Message-ID: <64bce1a2-c71b-4c10-a9ee-3aa47d71574b_at_p23g2000prp.googlegroups.com>
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:
- Oracle version.
- An actual screen-scrape (copy/paste) of a session that displays the behaviour in question.
- The relevant section of the alert log with the errors involved.
ORA-4192986 is not an Oracle error that I can find.
HTH -g Received on Mon Jan 19 2009 - 06:14:19 CST