Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Control data file format help

Control data file format help

From: Jay <mighty_dragon_at_hotmail.com>
Date: Fri, 01 Oct 1999 10:53:48 -0500
Message-ID: <37F4D90C.7BE51D64@hotmail.com>


Hello,
The control file used by sqlloader below would not load successfully. I can't seem to find the correct settings to load the data. Note that I must choose the character "|" as the delimiter for each field. Please give suggestions on how to load the ff. data.

Thanks in advance for help.

Table LIM_LIBRARY_BOOKS, loaded from every logical record. Insert option in effect for this table: APPEND

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- --------
NAME                           FIRST    *   |   CHARACTER
B_ID                           NEXT     1       CHARACTER
AUTHOR                         NEXT     *   |   CHARACTER
YEAR                           NEXT     1       CHARACTER
KEYWORDS                       NEXT     *   |   CHARACTER
ENTRY_DATE                     NEXT     9       DATE DD-MON-YY

Record 1: Rejected - Error on table LIM_LIBRARY_BOOKS, column YEAR. ORA-01722: invalid number

Record 2: Rejected - Error on table LIM_LIBRARY_BOOKS, column YEAR. ORA-01722: invalid number

Record 3: Rejected - Error on table LIM_LIBRARY_BOOKS, column YEAR. ORA-01722: invalid number

Table LIM_LIBRARY_BOOKS:
  0 Rows successfully loaded.
  3 Rows not loaded due to data errors.   0 Rows not loaded because all WHEN clauses were failed.   0 Rows not loaded because all fields were null.

Space allocated for bind array:                  50816 bytes(64 rows)
Space allocated for memory besides bind array:        0 bytes
****************************************************


Received on Fri Oct 01 1999 - 10:53:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US