| sql*loader loading blanks [message #173124] |
Fri, 19 May 2006 08:43  |
bogey
Messages: 53
Registered: February 2006
|
Member |
|
|
I'm trying to load from TOAD the below data. When I look at my schema table its showing blanks and when I do a select count(*) its showing my 66k rows but I'm not seeing any data.
I've exported my sql server data to a csv file that looks like this (I'll put line #'s to show each line)
1. RPFHSR,Human Subjects Research,10,2001-12-19 00:00:00.000,10-30
2. RPFRESHIP,Privacy Requirements for Researchers under HIPAA,10,2003-04-02 16:32:19.390,10-23596
Here is my control file
LOAD DATA
INFILE 'C:\Documents and Settings\xx\Desktop\dan.csv'
BADFILE 'C:\Documents and Settings\dbogesdorfer\Desktop\dan.bad'
DISCARDFILE 'C:\Documents and Settings\xx\Desktop\dan.dsc'
INTO TABLE "xx"."RPF_LEGACY"
INSERT
FIELDS TERMINATED BY ','
(LEGACY_MODULE_ID ,
LEGACY_MODULE_TITLE,
MPID,
COMPLETION_DATE,
CERTIFICATE_NUMBER)
Here is my logfile:
SQL*Loader: Release 10.1.0.4.0 - Production on Fri May 19 09:39:27 2006
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Control File: C:\Documents and Settings\xx\Desktop\load_rpf.CTL
Data File: C:\Documents and Settings\xx\Desktop\dan.csv
Bad File: C:\Documents and Settings\xx\Desktop\dan.bad
Discard File: C:\Documents and Settings\xx\Desktop\dan.dsc
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Table "ITEACH"."RPF_LEGACY", loaded from every logical record.
Insert option in effect for this table: INSERT
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
LEGACY_MODULE_ID FIRST * , CHARACTER
LEGACY_MODULE_TITLE NEXT * , CHARACTER
MPID NEXT * , CHARACTER
COMPLETION_DATE NEXT * , CHARACTER
CERTIFICATE_NUMBER NEXT * , CHARACTER
Table "ITEACH"."RPF_LEGACY":
66192 Rows successfully loaded.
0 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: 82560 bytes(64 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 66192
Total logical records rejected: 0
Total logical records discarded: 0
Run began on Fri May 19 09:39:27 2006
Run ended on Fri May 19 09:39:33 2006
Elapsed time was: 00:00:06.00
CPU time was: 00:00:00.90
|
|
|
|
| Re: sql*loader loading blanks [message #173317 is a reply to message #173124] |
Sun, 21 May 2006 14:56  |
 |
Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
|
I don't use Toad, but your code looks fine and the log file seems to indicate that it has run without errors. Perhaps Toad is waiting for a commit or some such thing? Have you tried it without Toad?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
