Re: Oracle DBA batch input from flatfile

Ben Hui <hui_ben_at_mdd.comm.mot.com> wrote:
>Hi all
>
>I am in the process of Investigating data transfer from a data flat file
>for a implementation in the oracle 10 database and am in need of some
>guidance as to how I can do this. What commands should I use that may
>reflect the same results as using the standard Oracle forms Interface
>but executing from the character mode command line via a flatfile.
>
>thx
>
>Ben

Ben,

You should consider the possibility of using SQL*Loader for bulk data loads from flat files. SQL*Loader is well suited for loading both delimited data from free-format files and field positioned data such as would be produced by a reporting package.

SQL*Loader is somewhat limited in that it can only insert rows into an empty table or append rows to a populated table, but it is highly optimized for doing large loads fast.

By using the direct path method with SQL*Loader, you avoid most of the sql overhead associated with scripted inserts in SQL*Plus, data entry with forms apps, and loading from flat files through a 3GL program. Also, with the direct path, you have the capability of populating indexes on a table while the data are being loaded.

hope this helps

regards,
Chuck

-- 
********************************************************************
Chuck Wolfe                         Phone:  (703)325-3718
Senior Consultant                   E-mail: cwolfe_at_ix.netcom.com
TELOS Consulting Services
460 Herndon Parkway
Herndon, VA 22070

I don't want the world, I just want your half...

********************************************************************