请问如何将这些数据导入ORACLE表中?

Question

13615857334  2008-09-03 00:00:02  66660A433047094648000C49000B4A000A4B00104C00084D000B4E000B4F000C63CE500000000D5100000009520000001D57005800D0DD66660A433047094248000C49000A4A000A4B000A4C000A4D000B4E000B4F000C63CE500000000D5100000009520000001D57005800C7DD
13587336413  2008-09-03 00:00:02  66660A01304706B948000B4900094A000C4B00094C00094D00094E00094F0000000D500000000E5100000017520000000C57005800C1DD66660A01304706BB48000B49000A4A00094B000A4C000A4D00094E000A4F0000000D500000000E5100000017520000000C57005800C4DD
13516756942  2008-09-03 00:00:05  66660A23304708EB4809BA49000A4A000A4B00094C000C4D000A4E00114F00000012500000000C510000000D520000000E57005800D5DD
13615857334  2008-09-03 00:00:05  66660A433047094648000C49000B4A000A4B00104C00084D000B4E000B4F000C63CE500000000D5100000009520000001D57005800D0DD66660A433047094248000C49000A4A000A4B000A4C000A4D000B4E000B4F000C63CE500000000D5100000009520000001D57005800C7DD
13587336413  2008-09-03 00:00:06  66660A01304706B948000B4900094A000C4B00094C00094D00094E00094F0000000D500000000E5100000017520000000C57005800C1DD66660A01304706BB48000B49000A4A00094B000A4C000A4D00094E000A4F0000000D500000000E5100000017520000000C57005800C4DD
13516756942  2008-09-03 00:00:09  66660A23304708EB4809BA49000A4A000A4B00094C000C4D000A4E00114F00000012500000000C510000000D520000000E57005800D5DD
13615857334  2008-09-03 00:00:09  66660A433047093D48000B4900094A000A4B000A4C000D4D000A4E000B4F000C63CE500000000D5100000009520000001D57005800C2DD
13757515614  2008-09-03 00:00:10  66660A09304706F648000C49000A4A000A4B00094C000A4D000A4E000B4F0000000E50000000095100000009520000000857005800F4DD66660A09304706F248000B49000B4A000A4B000A4C000A4D000D4E000A4F0000000E50000000095100000009520000000857005800F3DD66660A09304706F248000949000A4A000A4B000A4C000A4D000A4E000A4F0000000E50000000095100000009520000000857005800EDDD66660A09304706F548000B49000A4A00094B000B4C00094D000B4E000A4F0000000E50000000095100000009520000000857005800F2DD
13587336413  2008-09-03 00:00:10  66660A01304706BE48000B49000B4A000A4B00094C000A4D00094E00094F0000000D500000000E5100000017520000000C57005800C7DD66660A01304706BB48000B49000A4A00074B000A4C000A4D00084E000D4F0000000D500000000E5100000017520000000C57005800C4DD
13516756942  2008-09-03 00:00:13  66660A23304708EA4809BA4900094A000B4B000A4C000A4D000A4E000B4F00000012500000000C510000000D520000000E57005800CDDD66660A23304708EF4809BD49000B4A00094B00094C00094D000A4E000A4F00000012500000000C510000000D520000000E57005800D2DD
13615857334  2008-09-03 00:00:13  66660A433047093D48000B4900094A000A4B000A4C000D4D000A4E000B4F000C63CE500000000D5100000009520000001D57005800C2DD
13587336413  2008-09-03 00:00:14  66660A01304706BE48000B49000B4A000A4B00094C000A4D00094E00094F0000000D500000000E5100000017520000000C57005800C7DD66660A01304706BB48000B49000A4A00074B000A4C000A4D00084E000D4F0000000D500000000E5100000017520000000C57005800C4DD
13516756942  2008-09-03 00:00:17  66660A23304708EA4809BA4900094A000B4B000A4C000A4D000A4E000B4F00000012500000000C510000000D520000000E57005800CDDD66660A23304708EF4809BD49000B4A00094B00094C00094D000A4E000A4F00000012500000000C510000000D520000000E57005800D2DD
13615857334  2008-09-03 00:00:17  66660A433047093D48000C49000B4A000A4B000C4C000A4D00094E000A4F000C63CE500000000D5100000009520000001D57005800C2DD66660A433047092748000C49000A4A00094B000A4C000A4D000B4E00064F000C63CE500000000D5100000009520000001D57005800A6DD
13587336413  2008-09-03 00:00:19  66660A01304706B848000B49000A4A00094B000A4C00094D000B4E00094F0000000D500000000E5100000017520000000C57005800C1DD
13757515614  2008-09-03 00:00:19  66660A09304706F648000C49000A4A000A4B00094C000A4D000A4E000B4F0000000E50000000095100000009520000000857005800F4DD66660A09304706F248000B49000B4A000A4B000A4C000A4D000D4E000A4F0000000E50000000095100000009520000000857005800F3DD66660A09304706F248000949000A4A000A4B000A4C000A4D000A4E000A4F0000000E50000000095100000009520000000857005800EDDD66660A09304706F548000B49000A4A00094B000B4C00094D000B4E000A4F0000000E50000000095100000009520000000857005800F2DD
13516756942  2008-09-03 00:00:21  66660A23304708EB4809BA4900094A00094B000A4C00074D000A4E00094F00000012500000000C510000000D520000000E57005800C7DD
13615857334  2008-09-03 00:00:21  66660A433047093D48000C49000B4A000A4B000C4C000A4D00094E000A4F000C63CE500000000D5100000009520000001D57005800C2DD66660A433047092748000C49000A4A00094B000A4C000A4D000B4E00064F000C63CE500000000D5100000009520000001D57005800A6DD
13587336413  2008-09-03 00:00:23  66660A01304706B848000B49000A4A00094B000A4C00094D000B4E00094F0000000D500000000E5100000017520000000C57005800C1DD
13516756942  2008-09-03 00:00:25  66660A23304708EB4809BA4900094A00094B000A4C00074D000A4E00094F00000012500000000C510000000D520000000E57005800C7DD
13615857334  2008-09-03 00:00:25  66660A433047092F48000C49000A4A000B4B000A4C000A4D000A4E000B4F000C63CE500000000D5100000009520000001D57005800B4DD
13587336413  2008-09-03 00:00:27  66660A01304706BB48000B4900094A00094B00064C000A4D00094E00094F0000000D500000000E5100000017520000000C57005800BEDD请问如何导入到 no,time,vlaue 3个字段下?

Answer 1

表名叫做date 
字段no,time,vlaue 

Answer 2

SQL> show user
USER is "TEST"SQL> create table Tdate(no nvarchar2(50), Ttime nvarchar2(50),value varchar2(2000));Table created.创建控制文件test.ctl,内容：LOAD DATA
infile 'test.txt' 
into table tdate
FIELDS TERMINATED BY '  '
( 
  no, 
  ttime, 
  value 
)把你要导入的数据放到test.txt文件里面windowcmd窗口里面运行
C:\test>sqlldr userid=test/test control=test.ctlSQL*Loader: Release 9.2.0.1.0 - Production on Wed Sep 3 17:54:39 2008Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.Commit point reached - logical record count 21
Commit point reached - logical record count 22C:\test>
注：我把文件都放在c:\test文件夹里面从SQLplus 里面查询：SQL> select * from tdate;