Command to use SQL*LOADER

SQL*LOADER , a oracle based bulk loading utility. The following shows the way to load the data using the SQL*LOADER.

Using SID

sqlldr <Username>/<password>@"(DESCRIPTION\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=<HostName>)(PORT\=1521))(CONNECT_DATA\=(SERVER\=DEDICATED)(SID\=<SID>)))" control="Control_file.ctl" log="log.txt",bad="bad.txt" data="Data_file.csv"