Search Results

Actually, I'm able to print all the paths of remote host. Therefore, I can conclude that the env setting should be correct.

<<In remote host>>
$ echo "Oracle= ${ORACLE_HOME}"
RESULT: ...

No, is still not working after removing the '$' sign from shell scriipt.
I still will get " sqlldr: not found" error message

I have try command below to check sqlldr env variables, but it still...

I have tried to put env setting below inside Sqlldr.ksh
"
LD_LIBRARY_PATH=/oracle/product/10.1.0.4/CIDM/bin/
export $LD_LIBRARY_PATH
"

But, it showed error message :
...

All the paths inside sqlldr.ksh is hardcode and I'm able to execute the script in machine B (10.1.65.176).
I failed execute the scripts via remotely in machine A (10.1.65.116)

Dear expert,

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...

Many, thousands thanks to you.
It work:)

I can relax now.

HI,

Does anyone know how the alternative way to format date to 'Jul07' in UNIX-HP . I found HP Unix does not support date -d....:(
...

Hi,

I have a main program which have below lines

-
awk -f test.awk inputFileName
-
I wonder how to check status return from awk script.



content of awk script:
test.awk
---
if (...

Dear all,

Below is my script,

totalCount=57006427
totalSummCount=1207590
let percentageSumTmp1=${totalCount}-${totalSummCount}
let percentageSumTmp2=${percentageSumTmp1}*100

The expected...

My target limit is 60 million records.

Hi,

Do anyone know what's the max size of array (in awk)
can be store before hit any memory issue.

Regards

Below is my script. I calling PS/SQL named:dummy_select. I dun know what's wrong of it...Getting error : wrong argument type.

function checkFileStatus
{

sqlplus -S $USER/$PASS@$DB << EOF ...

can help .

Hi, can someone point out the tutorial or syntax for how to execute store procedure through shell scripting .

thanks.

I think I know how to do already.

sorry..it's fail. The script still will would not redirect the error "sqlerror.log" .
when have error, the error log is capture to "bulk_main.dat "
...

still the same error.
set term off didn;t help.

Hi,

I am new in shell scripting.
Can anyone point out what wrong of below script.
If I want the error output to "sqlerror.log"
and database pool data output to "bulk_main.dat".

Right now,...