Monday, 10 November 2014

Important Interview Question for Sql* Loader


This is one of the interview question which I faced regarding the sql*loader concept.

If  you are loading the data into table using sql*loader, Discarded records should not cross more than 10 while loading. How?


We are having an option in the sql*loader DISCARDMAX

It holds the integer value and if you pass DISCARDMAX=10, it will stop loading the data into table if the discarded records exceeds more than 10.

No comments:

Post a Comment

In how many ways we can link the requisition to purchase order in oracle ebs

 In Oracle E-Business Suite (EBS) R12 / R12.2, a Purchase Requisition can be joined to a Purchase Order across 4 primary levels , depending ...