dbTalk Databases Forums  

use copy command with error ORA--4192986

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss use copy command with error ORA--4192986 in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
NOVA
 
Posts: n/a

Default use copy command with error ORA--4192986 - 01-19-2009 , 05:19 AM






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@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

Reply With Quote
  #2  
Old   
gazzag
 
Posts: n/a

Default Re: use copy command with error ORA--4192986 - 01-19-2009 , 06:14 AM






On 19 Jan, 11:19, NOVA <nova1... (AT) gmail (DOT) com> wrote:
Quote:
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@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


Reply With Quote
  #3  
Old   
NOVA
 
Posts: n/a

Default Re: use copy command with error ORA--4192986 - 01-19-2009 , 06:49 AM



On Jan 19, 3:14*pm, gazzag <gar... (AT) jamms (DOT) org> wrote:
Quote:
On 19 Jan, 11:19, NOVA <nova1... (AT) gmail (DOT) 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@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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.