SQLLDR Problem
Date: 1997/04/08
Message-ID: <01bc4400$39bce220$3c4ba8c0_at_sos.sos-kd.org>#1/1
hi.
[Quoted] With all the discussion about trying to export records from a database, I
was hoping to get some help importing records. This problem is starting to
[Quoted] become rather thorny, and, so, ANY help is appreciated.
[Quoted] I am trying to import an ASCII file into a Oracle 7.2 database running on
Netware 4.1.
I am trying to use the SQLLDR.EXE utility from the \oracle_home\BIN
directory.
I took one of the \oracle_home\RDBMS72\LOADER examples and duplicated my error. Below is the information.
I should mention that my goal is to perform automatic inserting of about 30 [Quoted] megs of data in the database on a nightly basis. My idea was to write an external C program or batch program and call SQLLDR to load the data.
Also, and this is really wierd, if I use the console command NWLOADER, with [Quoted] the same control file, then the import goes without a hitch.
When I enter the following command:
sqlldr userid=scott/tiger control=a.ctl log=a.log bad=a.bad data=a.txt
discard=a.dis
I am greeted by the following results:
SQL*Loader: Release 7.3.2.2.0 - Production on Tue Apr 08 10:54:52 1997
Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
[Quoted] SQL*Loader-925: Error while parsing a cursor (via ocisq3) ORA-00904: invalid column name
Here is the ouput in the log file
SQL*Loader: Release 7.3.2.2.0 - Production on Tue Apr 08 11:00:47 1997
Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
Control File: a.ctl Data File: a.txt Bad File: a.bad
Discard File: dorf.dis
(Allow all discards)
Number to load: ALL Number to skip: 1 Errors allowed: 50 Bind array: 64 rows, maximum of 65024 bytes Continuation: none specified Path used: Conventional
Table DEPT, loaded from every logical record. Insert option in effect for this table: REPLACE
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ----
---------------------
DEPTNO FIRST * , O(") CHARACTER
DNAME NEXT * , O(") CHARACTER
LOC NEXT * , O(") CHARACTER
SQL*Loader-925: Error while parsing a cursor (via ocisq3) ORA-00904: invalid column name
Run began on Tue Apr 08 11:00:47 1997
Run ended on Tue Apr 08 11:01:04 1997
Elapsed time was: 00:00:17.76 CPU time was: 00:00:00.00 (May not include ORACLE CPU time)
Here is my control file.
LOAD DATA
INTO TABLE DEPT
REPLACE
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (DEPTNO, DNAME, LOC)
Here is my datafile
12,RESEARCH,"SARATOGA" 10,"ACCOUNTING",CLEVELAND 11,"ART",SALEM 13,FINANCE,"BOSTON" 21,"SALES",PHILA. 22,"SALES",ROCHESTER 42,"INT'L","SAN FRAN"
At this point, I would consider purchasing a unix pc as a viable
suggestion.
Thanks again for any help.
Jack
-- Jack Pawsat My problems are my own. My solutions belong to my boss.Received on Tue Apr 08 1997 - 00:00:00 CEST