sqlldr - exit error code 2 in unix (merged)
http://www.orafaq.com/forum/t/146582/
Thank you for your reply. Load has been successful all the time but I should not check the error condition (since I know there are going to be some errors) in order to continue the process I guess. But adding errors=9999999 and checking the error condition with $? will have the same result which will abort the process.
I really appreciated your time/effort in replying to my questions. Thanks very much and have a great day!
Hi pls provide your suggestion,
I'm using following command to th data.
sqlldr callctestapp/big5#ben@COMPASS_QA_APP, control=./EOBReportMember.ctl, log=../logs/reportMember.log, ERRORS=9999999
Flat file have 3 records, among hem 1 is dplicate. So two records are ussesfully loaded into the table.
But while running echo $? it give 2. Hence the script is getting failed. Can you please give your suggetion on this. Thanks in advance
Just curious where you saw error code 2 is incorrect usage of command? The documentation indicates that it's one of the following:
- All or some rows rejected
- All or some rows discarded
- Discontinued load
Error code 1 would indicate "Command-line or syntax errors".
最新文章
- NodeJS POST Request Over JSON-RPC
- SQL Server 数据库的维护(一)__存储过程(procedure)
- HTML 学习笔记 CSS样式(相对定位 绝对定位)
- Echarts-柱状图柱图宽度设置
- intelij idea 2016.2注册码
- 如何生成excel文件作为图像识别结果
- C#高级编程(第9版) -C#5.0&;.Net4.5.1 书上的示例代码下载链接
- 栈和队列的Java实现
- android技术牛人的博客[转]
- scanf 与 cin 的区别
- (hdu step 7.1.3)Lifting the Stone(求凸多边形的重心)
- RE模块垃圾回收机制
- SpringBoot(6) SpringBoot配置全局异常
- [20171120]11G关闭直接路径读.txt
- C++常量 运算符
- 自动化运维工具-mussh工具安装配置及简单使用讲解
- [hardware][intel] intel全系列网卡调研
- [转][linux]简单的linux下的tcp/udp
- Android - 自定义控件和属性(attr和TypedArray)
- centos7切换启动内核