oracle安裝在D盤,在命令行中輸入C:\>sqlldr userid=scott/scott@orcl control=c:\input.ctl 報錯信息如下SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] ORA-12154: TNS:could not resolve the connect identifier specified ctl文件內容如下: LOAD DATA INFILE 'c:\testWorksheet.csv' APPEND INTO TABLE testtable FIELDS TERMINATED BY "," (id,name,age) tnsnames.ora tnsnames.ora LISTENER_ORCL =   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ORCL =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = orcl)     )   )