dennis@cmsfl@labtam.oz (Dennis Papakyrikrpoulos) (12/07/89)
I have been working with the Oracle Data Loader, attempting to load raw data from operating system files into tables in the Database. My system confiquartion is an NCR Tower 32/650 running UNIX release 2.01, and Oracle v5.1. When the ODL utility has run I get a number of rejected record. Looking in the xxxx.bad log file they are records containing only spaces. These records are not part of the input file. I suspect that this has something to do with ODL reading blocks of records and when it comes to the end space filling the last block. Anyone else having or solved this problem ? An example ODL definition would be : DEFINE RECORD rec AS dummyfield (char(1)); DEFINE SOURCE FILE FROM test LENGTH 2 <--- this because of \n on each record CONTAINING rec; FOR EACH RECORD INSERT INTO testtbl ( dummyfield ) VALUES ( dummyfield ) NEXT RECORD +------------------------------------------------------------------+ | Dennis Papakyriakopoulos Phone: +61 3 829 6090 | | Programmer E-mail: dennis%cmsfl@labtam.oz.au | | Coles Myer Ltd. Post: PO Box 2000, Tooronga 3146 | | Australia | +------------------------------------------------------------------+