vb中读取大数据量文件到DB中（oracle）

1:利用oracle的load

2:oracle10g以上版本：Oracle.DataAccess

3:Data.OleDb.OleDbDataAdapter

 

1利用oracle的load

        Dim strBu As String = "sqlldr jjh/jjh@jjh control=g:\load.ctl"

        Dim psi As ProcessStartInfo = New ProcessStartInfo("cmd.exe")
        psi.UseShellExecute = False
        psi.RedirectStandardOutput = True
        psi.RedirectStandardInput = True
        psi.RedirectStandardError = False
        psi.CreateNoWindow = True
        psi.WorkingDirectory = "g:\"
        Dim process1 As Process = Process.Start(psi)

        process1.StandardInput.WriteLine(strBu)
        process1.Stand