sqlldr

[gnr]

what is sqlldr,how it is used in oracle

[i2eye]

It is SQL Loader, it is an oracle utility used to load data into your database from a text file.

In unix I use a control file to tell what location in the text file is to go into what column in the table.

Sqlldr is useful if you need to load thousands of data all at once.

[gauravupreti]

you can use SQL Loader from windows installation as well. Go to the Oracle installtion drive, bin folder. Use command prompt to run the sqlldr.exe file.

If you want to know more about control files and other command line options available with sql loader, pl refer to:

http://www.oreilly.com/catalog/orsqlloader/chapter/ch01.html
http://www.wisc.edu/drmt/sqlldr-pc.html
http://www.csee.umbc.e du/help/oracle8/server.815/a67792/ch05.htm

[anuj13singhal]

you can use SQL Loader from windows installation as well. Go to the Oracle installtion drive, bin folder. Use command prompt to run the sqlldr.exe file.

If you want to know more about control files and other command line options available with sql loader, pl refer to:

http://www.oreilly.com/catalog/orsqlloader/chapter/ch01.html
http://www.wisc.edu/drmt/sqlldr-pc.html
http://www.csee.umbc.e du/help/oracle8/server.815/a67792/ch05.htm

-------------------------------------------------------------------------------------------------------------------

If you have SQL loader file eg test_loader.ctl in the unix directory then write the following command to execute it

$ sqlldr userid=userid/password control=test_lo ader.ctl log=test_loader .log &

hope this works !!!!!!!!!