Login or Register to Ask a Question and Join Our Community


loading Binary files with SQLLDR


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting loading Binary files with SQLLDR
# 1  
Old 06-24-2008
Data loading Binary files with SQLLDR

Hi,

Can anyonr please tell how to load a binary file through SQLLDR.
I have the structure of the binary file in a seperate lb file but I don't know how to feed it to the sqlldr.
Login or Register to Ask a Question

Previous Thread | Next Thread

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... (4 Replies)
Discussion started by: Pratiksha Mehra
4 Replies

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.... (1 Reply)
Discussion started by: smileyreddy
1 Replies

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 * * * &&... (2 Replies)
Discussion started by: selvam
2 Replies

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... (4 Replies)
Discussion started by: rahulkav
4 Replies

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... (0 Replies)
Discussion started by: hemanty4u
0 Replies

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.. (1 Reply)
Discussion started by: mpsc_sela
1 Replies

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... (0 Replies)
Discussion started by: DILEEP410
0 Replies

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... (2 Replies)
Discussion started by: user_prady
2 Replies

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? (1 Reply)
Discussion started by: devildivine
1 Replies
Login or Register to Ask a Question
Binary.array(3kaya)					       Kaya module reference					       Binary.array(3kaya)

NAME
Binary::array - Return a block as an array. SYNOPSIS
[Int] array( Binary block ) ARGUMENTS
block The binary block DESCRIPTION
Return a block as an array of Int s. AUTHORS
Kaya standard library by Edwin Brady, Chris Morris and others (kaya@kayalang.org). For further information see http://kayalang.org/ LICENSE
The Kaya standard library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License (version 2.1 or any later version) as published by the Free Software Foundation. RELATED
Binary.Binary(3kaya) Binary.copyBlock(3kaya) Binary.getBlockChunk(3kaya) Binary.peek(3kaya) Binary.peekString(3kaya) Binary.setBlockData(3kaya) Kaya October 2012 Binary.array(3kaya)

Featured Tech Videos