del文件怎么导入到Oracle中

1、.del格式文件是db2导出的定界ascii文件：

db2

=>

export

to

emp.del

of

del

select

*

from

emp

2、[db2inst1@server9

~]$

vi

emp.del

"000010","christine","i","haas","a00","3978",19950101,"pres

",18,"f",19630824,+0152750.00,+0001000.00,+0004220.00

"000020","michael","l","thompson","b01","3476",20031010,"manager

",18,"m",19780202,+0094250.00,+0000800.00,+0003300.00

3、如果你要在db2导入.del文件

db2

import

from

myfile.del

of

del

insert

into

mytable

4、如果你要在oracle导入.del文件

你需要根据格式create

table,用toad

for

oracle

或者navicat

for

oracle导入txt即可。

命令行状态下，依次执行如下命令：

1.首先与DB2数据建立连接（如：数据库名为dbname）。

命令：db2 connect to dbname

2.将del文件(如：数据文件名为datafile.txt,存放在d盘根目录下)导入到数据中指定的table中（如：table名为deltable）。

命令：db2 import from d:\datafile.txt of del insert into deltable

希望对你有帮助

1、.del格式文件是DB2导出的定界ASCII文件：

db2 =>EXPORT TO emp.del OF DEL SELECT * FROM emp

2、[db2inst1@server9 ~]$ vi emp.del

"000010","CHRISTINE","I","HAAS","A00","3978",19950101,"PRES",18,"F",19630824,+0152750.00,+0001000.00,+0004220.00

"000020","MICHAEL","L","THOMPSON","B01","3476",20031010,"MANAGER ",18,"M",19780202,+0094250.00,+0000800.00,+0003300.00

3、如果你要在db2导入.del文件

db2 import from myfile.del of del insert into mytable

4、如果你要在oracle导入.del文件

你需要根据格式create table,用Toad for oracle 或者Navicat for oracle导入txt即可。

---