Recent content by yerra

How Do I do @file1, @file2 ... like this programmatically. It can be one file or many files.To explain better here is the logic of the script that I plan to use. for FILE in <Location_Of_All_SQLFILES_In_Unix> do sqlplus << ! @FILE exit; ! done In this case between Do and done, it will login and...

I have a folder in Unix /SQL which contains some SQL files that are to be loaded into the database. Some of these files contains procedures,functions, others are simple update, inserts statements. In Unix I read a file, load into oracle, exit and then read another file, load into oracle and...

I am using a windows telnet client. I also tried using putty (which is another telnet client) on my windows system. Still shows the same symptom..

No Actually I am using a telnet session to my server. In my terminfo file I have a setting for setting the col length to 132 i.e setting TERM to vt100 -w (which means set it to wide). Still it chops of the variable at 80th character , inserts a space and then continues with the variable.

I tried your code, it works ok, but If I want to display the values other than /oradata/archives in the else part of the print statement, then how do i go about this ?

I am using Dec Alpha v5.1 and I have a program that sets a variable value of which goes above 80 characters. So after 80 char, it puts a space/newline and hence I am not able to capture the entire value of the variable. Any Idea on how to go bout this ?

Thanks for the help.. I could get it.

I have a variable named ARCLOG with value ARCHIVELOG,/oradata/archives,46455433. Now I want to evaluate a condition where a) If value in 1st column is ARCHIVELOG, check the 2nd column for its location (/oradata/archives or any loc). if there is no value in 2nd column , then display a message...

I am using Dec AlPha V5.1. The query is ARCAREA=/archives ARCLOG=ARCHIVELOG,78643200 LOGSIZE=`echo $ARCLOG |awk -F, '{print $2}'` DISKSPACE=`df -k $ARCAREA |grep -v "Available" |awk '{print $4}'` TOTALLOG=`expr "$DISKSPACE" \* 1024 / "$LOGSIZE"` PERCSPACE=`df -k $ARCAREA | grep -v Capacity |...

I am writing a script to check the no of logs a directory can hold and % of disk space available. If directory can hold only 50 logs more or disk % available is only 80% then Alert the admin. Though the below code works, I was looking at a better script which might elimnate calling df -k...

Supposing I have a directory with 100 files and I need to find out the Top 5 Files sorted by Size. Can Someone help me in this ..?