Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Control data file format help
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
![]() |
![]() |