Question

linux下怎么用命令导入oracle 备份.del格式文件

Answer 1

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即可。

追问

嘿嘿，这句话：根据格式create table,用Toad for oracle 或者Navicat for oracle导入txt即可。没懂具体怎么做。请详解，谢啦。

Answer 2

我不知道oracle的备份文件还有del格式的？
如果是dmp格式的话使用imp命令导入
示例如下：
imp user/passwd@oraclesid fromuser=xxx touser=user ignore=y file=文件路径和名称.dmp log=日志文件路径和名称.log

Answer 3

使用import导入数据：
imp scott/tiger@linuxoms fromuser=scott touser=scott file=c:\dony\bankuser.dmp log=c:\dony\bankuserimp.log
你非要弄个格式不可。可以把dmp改一下