首頁(yè) 猿問(wèn) 求高手如何解決啊?報(bào)錯(cuò)信息如下：

求高手如何解決啊?報(bào)錯(cuò)信息如下：

SQL Server

精慕HU 2023-04-20 18:14:58

oracle安裝在D盤,在命令行中輸入C:\>sqlldr userid=scott/scott@orcl control=c:\input.ctl 報(bào)錯(cuò)信息如下SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] ORA-12154: TNS:could not resolve the connect identifier specified ctl文件內(nèi)容如下: 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) ) )

查看完整描述

2 回答

明月笑刀無(wú)情

TA貢獻(xiàn)1828條經(jīng)驗(yàn) 獲得超4個(gè)贊

這個(gè)應(yīng)該是因?yàn)檫@個(gè)用戶沒(méi)有訪問(wèn)這個(gè)數(shù)據(jù)庫(kù)的權(quán)限或者這個(gè)數(shù)據(jù)庫(kù)不存在，你用系統(tǒng)用戶訪問(wèn)這個(gè)數(shù)據(jù)庫(kù)試試。
sqlldr userid=scott/scott@數(shù)據(jù)庫(kù)名 control=c:\input.ctl

反對(duì) 回復(fù) 2023-04-23