sql loader总是报错,SQL*Loader-704 ORA-12154

Question

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)
)
)

求高手如何解决啊?

Answer 1

[code="java"]
C:>sqlldr userid=scott/scott@orcl control=c:\input.ctl

切换成D盘 D：
如果oracle 没安装成功家我QQ503229799我给你文档。
[/code]