loading Binary files with SQLLDR

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem loading default date column in sqlldr

Hi All, My control file looks like: LOAD DATA APPEND INTO TABLE MK9210_PROD_DL.MK9210_PROD_EG_6 FIELDS TERMINATED BY '|' TRAILING NULLCOLS ( STUDY CHAR ,PATIENT INTEGER EXTERNAL ,CPEVENT CHAR ,NAMEG CHAR ,REFIDEG CHAR ,POSEG CHAR ,METHEG CHAR ,EGDAT CHAR ,EGTIM CHAR ,COMEG CHAR...

2. Shell Programming and Scripting

Need some help on scripting for validating the files before loading

Hi, I need to perform some validation steps on the files before I start loading them. 1. I need to check for the availabilty of the file in expected path with expected name. 2. I need to check If the file format is correct. a. confirm if correct delimiter is used. b....

3. UNIX for Advanced & Expert Users

Help with loading config files

Hi All, I'm bit confused with a script Any help would be appreciated I have a config file say config.cfg and iam loading config file in My_Script.sh..The script name is My_Script.sh. My_Script.sh and config.cfg are in same directory...My_Script.sh is run on the crontab 50 01 * * * &&...

4. Shell Programming and Scripting

Binary files

Hi All,Is there anyway I can conver the binary file to ascii. I don't know the binary file format. file command just lists this as "data" file and when I view it has a lot of non-printable characters.Can I write any command equivalent to wc -l to find out the number of rows in the file?Can I use...

5. UNIX for Advanced & Expert Users

Loading files incrementaly

Hi Am trying to sftp this way UnixBoxA----->UnixBoxB My code will run on UnixBoxB, it will make a secure connection and pull the files from UnixBoxA. Apart from that I do not have any access on UnixBoxA Now UnixBoxA will receive the files daily, the file format will be...

6. Shell Programming and Scripting

Function loading in a shell scripting like class loading in java

Like class loader in java, can we make a function loader in shell script, for this can someone throw some light on how internally bash runs a shell script , what happenes in runtime ... thanks in advance..

7. SuSE

sqlldr : charset conversion while loading ?

Hi, I am a newbie to Linux(Suse).I am facing a problem with 'sqlldr' utility while trying to upload data to Database tables.My backend is Oracle and is using the UTF8 encoding format.I am trying to load a datafile which contains some Western European Characters.While loading am getting an...

8. Shell Programming and Scripting

search for files excluding binary files

Hi All, I need a solution on my following find command find ./.. -name '*.file' -print BTW This gives me the output as belows ./rtlsim/test/ADCONV0/infile/ad0_dagctst.file ./rtlsim/test/ADCONV0/user_command.file ./rtlsim/test/ADCONV0/simv.daidir/scsim.db.dir/scsim.db.file...

9. UNIX for Dummies Questions & Answers

Binary Files

Does any one know how to view a binary file as it is (in 1s and 0s) on unix environment?

Shell Programming and Scripting