1.初始的数据:
例如:
LOAD DATA
INFILE *
BADFILE './DATA24.BAD'
DISCARDFILE './DATA24.DSC'
APPEND INTO TABLE GE_L_TEMP
Fields terminated by ";" Optionally enclosed by '"'
(
ID,
C_DEST,
R_DEST,
GR_SRC,
AP
)
BEGINDATA
3482845;0;0;0;"1";"41112830"
3482846;0;0;0;"1";"thx";3;105
2. CMD下使用的语句:
sqlldr userid=showdata@prod control=data.ctl
其中重点看下服务名:
@prod
1).此服务名一定要在server下的tnsnames.ora进行配置,而不是client下。。
prod=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prod)
)
)
2). PING一下:tnsping prod
3) 查看一下监听状态 :lsnrctl status
如果没有起动,使用命令起动:lsnrctl start