Search results for query: *

Thanks Santa. I will let you know once done.

Hello, we have a datafile of initial size 500MB on a 8i DMT. Auto increment of 500MB. Max size is 2GB. Can we increase initial size to 1GB? How complicated is the procedure?

May I know what's wrong here?

prompt>type date date is a tracked alias for /usr/bin/date prompt>date Thu Jun 10 16:06:29 EDT 2004

prompt>(TZ=X-19; export TZ; date; echo $TZ) Thu Jun 10 15:40:06 EDT 2004 X-19

prompt>export TZ=X-19; date Thu Jun 10 15:14:27 EDT 2004

prompt>TZ=X-19 date Thu Jun 10 15:06:42 EDT 2004

echo $TZ EST5EDT

The date command displays or sets the current HP-UX system clock date and time. Since the HP-UX system operates in Coordinated Universal Time (UTC), date automatically converts to and from local standard or daylight/summer time, based on your TZ environment variable. TZ determines the...

O.S is HP-UX 11i. I don't exactly know what shell I am using. When I say which shell, it returns /usr/bin/sh. And as export name=value is valid in my scripts I assume it is korn.

This function is to to get any date in the past or in the future from today. So -1 is used to get yesterday's date. 1 for tomorrow's date .....

Any ideas please?

Can we remove spaces from a string variable? Ex: If $var has 10 20 2003, it should become 10202003. Thanks.

Sorry if I got it wrong. I used this function and it gives me the same date. Script: #!/usr/bin/sh # GetDate nDays [format] GetDate () { set -x typeset -i nDays=$1; format=$2 typeset -i localOffset=$(echo $TZ | sed 's![^-0-9]*\([-0-9]*\).*!\1!') TZ=X$((localOffset-24*nDays)) date...

I found the solution. I had to include . profile in the script. It basically kills the current running agent and recreates ssh-agent.

Thanks. The client's public key is in both servers. The same script when executed at prompt, just connects well and writes down the output to a file. If run from crontab, the script writes output relating to client (local ) machine but not the remote machines.

I have a script that does ssh connection to a remote server and runs well. I put the same script in cron. It doesn't seem to connect to the remote server. The script runs displaying all but the remote command output. I am using user crontab from my user login. Any ideas why the script is running...

I tried using echo "SELECT count(*) FROM PLAN_TABLE;" | ssh userid@serverb '. /home/oracle/.profile;sqlplus -s system/dem@servb' > outputfile. I am getting a lot of extra information before the output line. I made it like this: exec 1> ${SQLTEMP} exec 2>/dev/null ssh...

Thanks. Can we spool the output here?

count(*) is 400.