Search Results

Have you tried putting those commands into a script?

ie:

echo "cd <path>" >file1.ksh
echo "cat <filename>" >> file1.ksh
chmod +x file1.ksh

make sure it's owned by <username>

then try...

Define "full path" .
is it:

1) starting with a slash "/" ?
then just check first character for a "/"


IAMIN=`pwd`

if [[ `echo $IAMIN | cut -c1` == "/" ]]
then
echo true
else
...

Increase the size of your TEMP tablespace - it's not big enough ..

SQL> create table junk
2 (field1 number,
3 field2 number,
4 field3 number )
5 /

Table created.

SQL>
SQL> insert into junk values ( 3291234567, 333991123456789,...

Simple method might be something like:


for i in `cat $file2`
do
head -$i $file1 | tail -1
done


not sure if there's a cleaner or more efficient way, though :)

Probably a rookie answer here, but if you're talking just scanning for the first error in a given log file, I've used this logic successfully in the past:


LN=`grep -n "<error>" <log_file> |...

Well, that's why I suggested external tables first :)

But from a DB standpoint, I see the data as needed in the database, hence the load. Agreed, he didn't explicitly ask how to load it, but...

Perhaps I'm completely missing the point, however, why don't you just use "which"

> which grep
/usr/bin/grep

Let the system do the heavy lifting for you?
Now you have the full path to the...

Understood, however, the only issue I was trying point out was that because of that bit-wise fun, depending on the error code sent back, it *could* come back as 0, despite throwing an error.
(ie if...

That won't quite work as expected:

> more gg.sql
whenever sqlerror exit sql.sqlcode;

select 1/0 from dual;

exit

> sqlplus -s myid@mydb @gg.sql
Enter password:
select 1/0 from dual
...