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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Use sql*loader

RE: Use sql*loader

From: Raymond Lee Meng Hong <RAYMOND_at_infopro.com.my>
Date: Fri, 22 Jun 2001 00:55:26 -0700
Message-ID: <F001.00333405.20010622004532@fatcity.com>

<SPAN

class=280423107-22062001>Yes..you might need to set the buffer to some more higher ?? but did you check on your log file or is there any bad file produce ??
They
might be data error while loading it..
<SPAN

class=280423107-22062001> 

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Ngo BaDu   [mailto:ngo_duy_at_fmail.vnn.vn]Sent: Friday, June 22, 2001 3:50   PMTo: Multiple recipients of list ORACLE-LSubject: Use   sql*loader
  Dear all,
  I have a text file of 700000 rows. After   using sql*loader to load it into my table, I select * from my table it   only show 802 rows.
  Some people told me that's because of buffer. Who   would like to show me how I ought to do? Thanks you and sorry for my bad   english.
  BaoDuy Received on Fri Jun 22 2001 - 02:55:26 CDT

Original text of this message

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