Recent content by Ogzilal

Because it looks for "/nfs_l1 " as a whoole word space included. If you uncote /nfs_l1 , it will ignore trailing spaces

If your column is the last in the file and if you have "rev command" installed reverse twice rev /path/to/file | awk -F"," '{print $1}' |rev and then remove " and ' using sed tr or your favorite tool

It can be matter if the old crontab contains the same action scheduled at 9:01 and was edited using say vi to change the time at 10:01.

How did you put this line in crontab ? 1 10 * * 0,2-6 ksh -c "/sitemgr/backup/bkupproc/appbkup.ksh rmt1" By using crontab -e ( which edit and restart cron daemon ) or by editing the underlied file using your favorite editor in which case, you are still using old crontab.

At first glance, it looks OK. Repalace Displaymenu with displaymenu in the definition of the function Replace echo `DATE` with date and call your functions in the while loop while true do displaymenu read answer case $answer in 1) do_takeon ;; 2) do_expired ...

date --date="-1 month" +%Y-%b-%d 2010-Jan-17

If you are using Linux, you can write something like this to get date one month later date --date="-1 month" +%Y-%m-%d 2010-01-17

Same code with reuse X variable Counter=0 while [ $Counter -le 3 ]; do eval X=Input$Counter echo $X eval $X=$(cat /tmp/lst$Counter | awk '{print $1}') eval Y=\$$X echo $Y Counter=`expr $Counter + 1` done

Hi, think eval if you want some pointer behaviour that works in two times Counter=0 while [ $Counter -le 3 ]; do eval X=Input$Counter echo $X eval $X=$(cat /tmp/lst$Counter | awk '{print $1}') eval Y=\$Input$Counter echo $Y Counter=`expr $Counter...

Like this using man seq for details #! /bin/ksh for HH in $(seq 0 23) do for MN in $(seq 0 5 55 ) do printf "%.2d:%.2d\n" $HH $MN done done

If you need access to array elements, here is some code going that way #! /bin/ksh for ARRAY in Tab1 Tab2 do # some Array initialisation case $ARRAY in Tab1) eval set -A $ARRAY aaa bbb ccc ddd eee ;; Tab2) eval set -A $ARRAY 111 222 333 444 555...

Hi, Try this code for FILENAME in $(ls *.err ) do echo ${FILENAME%.*.err} done

Hi, This grep will discard all DROP lines with a 4 chars tablespace name grep -v "DROP TABLESPACE.......INCLUDING CONTENTS CASCADE CONSTRAINTS" drop.sql > drop.sql_modified 7 dots stands for 2 spaces and 4 chars tablespace name and a space. SYSAUX and SYSTEM will be discarded

Hi, I think you mean sftp connections without giving password. If so, google "ssh without password" and surf over displayed links

Hi, I am running an Oracle 9.2.0 on AIX box. The installation was made from a tape and I dont have the original set of CDs to run OUI. Is there an SQL command that lists the set of installed patchs In advance, Thanks