SQLLDR 示例

sqlldr name/passward@nrms control=C:\Users\Administrator\Desktop\fiew\YDHX_ROUTER_CARD.ctl data=C:\Users\Administrator\Desktop\fiew\127-MOBILE-ROUTER_CARD-20190629040023.csv direct=true rows=1000

CTL 文件

-- SQL Loader Control and Data File created by TOAD
-- Variable length, terminated enclosed data formatting
-- 
-- The format for executing this file with SQL Loader is:
-- SQLLDR control=<filename> Be sure to substitute your
-- version of SQL LOADER and the filename for this file.
--
-- Note: Nested table datatypes are not supported here and
--       will be exported as nulls.
LOAD DATA
TRUNCATE INTO TABLE YDHX_ROUTER_CARD
Fields terminated by "," Optionally enclosed by '"'
(
ALIAS,
REGION_ID,
EMS,
EQP_TYPE_ID,
EQP_SEQUENCE,
EQP_MODEL_ID,
MFR_ID,
MANAGE_IPADDRESS,
HDWE_VER,
SW_VER,
SW_PATCH_VER,
NMS_ORIG_RES_ID,
NMS_ORIG_RES_NAME,
EMS_ORIG_RES_ID,
EMS_ORIG_RES_NAME,
CPU_IDENTIFI,
CPU_FREQUENCY,
MAC_ADDRESS,
NET_LEVEL,
LOOPBACK
)