Search Results

I'm using the below command but .txt is appended to the beginning of the file names not in the end. how to display it like filename.txt?

for test in `cat files.lst`; do echo $test".txt"; done
...

I'm running by executing a shell script, given absolute path same error.

I ran in unix prompt sqlldr by giving just the name of the par file without path(ctl, par all in the same directory) it...

Still I'm getting the same error

Hi

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

When I run this command ps -ef | grep pmon, I get 2 outputs, one is 'myuser' and the other one as 'oracle' user

Hi

When I use sqlplus in shell script, I get sqlplus: command not found.

ORACLE_HOME is not set. How to set ORACLE_HOME in unix?

Thanks

Thanks it works

I have another question. Declared a variable like test="../path"

Referring the variable as $test/file_name.txt

Where does the directory 'path' needs to be created in the...

Hi

I'm using the below command in shell script to check for file exists in the path

if [ ! -r $path/$test.csv ]
.....
fi

path and test are variables

path and the file exists but the...

Hi all,

I have a doubt in SQL Loader.

We have SEQUENCE function in SQL Loader or can create Sequence in Oracle database for generating a number sequence for

a column while loading data...