Posted by 'S.Ramakrishnan' on August 11, 2001 at 15:52:32 EST:
Dear all ,
I have created a link from conversant local database
to Oracle 8i database in db-server as follows
Create public database link nbolink connect to system
identified by manager using 'dbserve'
dbserv is defined in /etc/hosts.
The link is working fine. But when I use the link to
update the Oracle 8i database from conversant I get the
following error.,
UNIX_SV> sqlldr system/manager@nbolink
control=control.txt
SQL*Loader: Release 7.3.2.3.0 - Production on Sat Aug
11 23:38:52 2001
Copyright (c) Oracle Corporation 1979, 1994. All
rights reserved.
SQL*Loader-925: Error while parsing a cursor (via
ocisq3)
ORA-00942: table or view does not exis
My Control file is as follows ...
Load DATA
INFILE '/home/Faxserver/Faxreport/2001Aug9.scs'
APPEND INTO TABLE FaxSentTbl1
FIELDS TERMINATED BY "|"
(AccountNo,
DateOfOutFax,
SerialNumber,
FaxNumber,
NoOfpages,
StartTime,
DurationOfOutFax)
Pls help.
Thanks & Regards
Ramki