Methods Of Uploading Data to Oracle Tables

[TheMus]

I'm using sqlldr80 to import records into an Oracle table. Is there another method of getting the records into the table?

Thanks in advance,

Rus

 

[listener22]

ms access, if it can read from your input file Jim

oracle, vb

 

[hacketta]

You could use one of the Oracle Precompilers or the PL/SQL file I/O built-in package UTL_FILE to read the file and then perform inserts into the appropriate table. SQL*Loader is probably easiest unless you want to do some pretty complicated data cleansing etc.

 

[RJSHA1]

If you are looking for spped will inserting I would use Pro*C.

Also use temporary tables to store the data and have a second job load it onto the relevant tables on the database. Or if you have no manipluation to do just insert it in your Pro*C job


hope this helps....