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 -> Re: Batch insert data into oracle from text file.

Re: Batch insert data into oracle from text file.

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 22 Dec 2005 18:03:47 GMT
Message-Id: <pan.2005.12.22.18.03.47.339300@sbcglobal.net> 





On Thu, 22 Dec 2005 17:45:27 +0800, Scarab wrote:



> Because I have about 3G files to import every day, so performance is greatly

> valued.




If you can make directories where the files reside available to the
database server (not always possible), you can use external tables.
That is the best and the most inexpensive solution.


-- 
http://www.mgogala.com


Received on Thu Dec 22 2005 - 12:03:47 CST












Original text of this message













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