SQL*Loader DISCARDMAX Parameter

This parameter specifies the maximum number of discard records can be allowed during a particular data load. This is a number parameter and if you are not specifying any number for this argument then it will consider all discard records. Otherwise it will exit the data load once it reaches the limit. See an example below

Here is my data file

How to Remove / Hide Post Counter from Blogger Archive Widget in New Interface

Generally there would be a number of post counter with blogger archive widget. If you don’t want to show the number of posts against each month/year you can use the following method to hide the counter.

How to Hide / Remove ‘Subscribe to: Post Comments (Atom)‘ From the New Blogger Interface 2013

Subscribe to: Post Comments (Atom) is the link for subscribing the atom feeds from the blog posts. It generally comes under the each and every blog post. It is consumes some space under each and every post and it is not relevant for the blogs much. You can follow the below method to remove / hide this Subscribe to: Post Comments (Atom) link.

Shell Script to Execute Oracle Sql Script in Crontab for a Specified SID

For general shell script to execute SQL statements does not require the environment as those required parameter might be set already for the sessions. But when it comes to Crontab job, script will run independently from other sessions and it needs all the required parameter to be set inside the script.

What are the required parameters to run a SQL in a Crontab shell script?

How to Automate / Schedule Oracle Gather Table Statistics Job through Crontab?

Step 1: Create a shell script to accept a sql file and execute against a particular database. Make necessary changes to the ORACLE_SID, ORACLE_BASE, ORACLE_HOME parameters.

$ vi sql.sh

export ORACLE_SID=transprd

export ORACLE_BASE=/u00/app/oracle

export ORACLE_HOME=/u00/app/oracle/product/11.2.0.3/db_1

export

SQL Loader bad file vs Discard File: Difference and Examples

BAD File contains the records which are rejected either by SQL Loader or by the database because of the bad formatting or data type mismatch.

More details and example here.

DISCARD file is to store the records that are neither inserted into table nor rejected as bad. This is an optional parameter with SQL Loader and by default name would be .dsc.

Oracle SQL Loader Bad file (.bad) Parameter Example

The BAD parameter specifies the name of bad file created by SQL*Loader to store the records that rejected during the insert process because of the data type mismatch or improper format. If the file name is not specified, by default the SQL*Loader will take the .bad as the file name. If you specify the bad file name with parameter bad then it will override the default file name. See some examples below.