oracle 加载文本文件
oracle 加载文本文件1.编写控制文件 input.ctlLOAD DATA INFILE 'c:1.txt' APPEND INTO TABLE houzi FIELDS TERMINATED BY ","(no1,no2,no3)2.执行控制文件C:Documents and Settingshp>sqlldr scidata/xxx@gdass control=c:input.ctlSQL*Loader: Release 9.2.0.1.0 - Production on Wed Aug 27 15:18:01 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Commit point reached - logical record count 3Commit point reached - logical record count 4[@more@]
滚滚长江东逝水
滚滚长江东逝水 浪花淘尽英雄是非成败转头空 青山依旧在 几度夕阳红白发渔樵江渚上 惯看秋月春风一壶浊酒喜相逢 古今多少事 尽付笑谈中 [@more@]