2013/07/19 SQLLDR文件

SQLLDR 加载只能加载当前文件夹内文件

 

总共产生会有5种文件 控制文件 数据文件                     SQLLDR使用的文件  控制文件和数据文件可以一体

                                       log 文件 bad文件   废弃文件     log文件执行sqlldr命令时会产生；

                                                                                                             如果有不能导入的数据产生bad文件不

                                                                                                符合when语句条件的会产生在指定的废弃

                                                                                               文件中，不指定不产生，且重复数据

                                                                                              只显示一条

                       两种指定方式： 导入声明SQLLDR system/password

                                                                         control=emp.ctl discard =emp.dsc

                                                                                                        或者控制文件声明 LOAD DATA
                                                                                             INFILE emp.txt
                                                                                             INFILE emp1.dat
                                                                                             DISCARDFILE EMP1.DSC
                                                                                             APPEND INTO TABLE emp

log

bad

 

dsc