10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
i have a file having 5 columns with more than million records. And i want to search using UNIX command to find if there are any spaces in 5th column. any please help. (1 Reply)
Discussion started by: sivakumar.p
2. Shell Programming and Scripting
My control file looks like:
INTO TABLE MK9210_PROD_DL.MK9210_PROD_EG_6
FIELDS TERMINATED BY '|'
,PATIENT INTEGER EXTERNAL
,COMEG CHAR... (4 Replies)
Discussion started by: Pratiksha Mehra
3. UNIX for Dummies Questions & Answers
I hope to create a file made up of 2 columns
- first column print out number 0~61000 every 50 of it
- second column just contains 0
delineated by space
Which command should I need to use? I think I might need to use... (5 Replies)
Discussion started by: exsonic
4. Shell Programming and Scripting
I'm using SQL*Loader in shell script as below
sqlldr $uname/$pword@$ORACLE_SID parfile=$test.par
for e.g. if $test is 'file1'
and getting the below error
LRM-00109: could not open parameter file 'file1'
LRM-00113: error when processing file 'file1'
SQL*Loader: Release... (7 Replies)
Discussion started by: vinoth_kumar
5. Shell Programming and Scripting
What's the best way to split a large into multiple files based on the last digit in the first column.
f1... (9 Replies)
Discussion started by: alain.kazan
6. Shell Programming and Scripting
Genere un proceso en proC que me inserta registros a oracle, el cual ejecuto desde un shell en Unix. Por otro lado tengo un sqlldr que me hace el trabajo en un 25 % de tiempo que mi proceso en C.
Se que puedo ejecutar mi sqlldr desde un shell, pero no se como hacer, alguien tiene un... (0 Replies)
Discussion started by: marcoinxs
7. Shell Programming and Scripting
I've a batch program that load data from a file like:
I used the sqlldr command in this way:
sqlldr userid=U/P control=$SCRIPTS/CTRL.WCT data=$DATA/FILE log=$LOGS/FILE.LOG... (2 Replies)
Discussion started by: raippl
8. Shell Programming and Scripting
Can we invoke sqlldr command remotely.
When I try rsh command in machine 10.1.65.116, it's failed on sqlloader command. However, nothing wrong on the shell scripts or environment setting of the remote environment, I able to execute in the scripts in remote machine.
in machine... (8 Replies)
Discussion started by: epall
9. UNIX for Dummies Questions & Answers
Can anyone know how to get the error codes from 'sqlldr' ?While am trying to load some 'ISO-8859-1' data file into 'utf8' oracle database,some records are rejected.I want to know the reason,whether it is due to charset mismatch or some other issues.How come i to know that ?
... (3 Replies)
Discussion started by: DILEEP410
10. Shell Programming and Scripting
1.The below script works perfectly fine in dev. However, i have been told that i cannot hardcode the password into the file during production impementation. Is their way i could ask the user to enter the password when the script is executed
2. I have seven different files each of which needs to... (1 Reply)
Discussion started by: systemsb