Re: SQLLDR Problem

There is also a patch available from Oracle which will fix the problem. The patch is an SQL script run on the server which updates a system table used by the loader. This will allow the 7.3 loader to be used with an older version of the RDBMS.

Jack Pawsat <JACKPAWSAT_at_sprynet.com> wrote in article <01bc4400$39bce220$3c4ba8c0_at_sos.sos-kd.org>...
> hi.
> 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
> become rather thorny, and, so, ANY help is appreciated.
>
> 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
> 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
> 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.
>
> 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 Wed Apr 09 1997 - 00:00:00 CEST