|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
#Spool/Query executing with extra space.
Post 302897614 by Mohammed_Tabish on Tuesday 15th of April 2014 06:38:51 AM
04-15-2014
#Spool/Query executing with extra space.
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hi,
I'm in Solaris 2.8 env. When i'm trying to add a ftp user account ,
encountered "no space in disk" .. couldn't create any user. Then check the fs disk space with "df - k " and /var/adm/syslog .. got the below message.
Jun 9 03:10:53 mail sendmail: NOQUEUE: low on space
(have 0,... (10 Replies)
Discussion started by: Dolly
10 Replies
2. Shell Programming and Scripting
Hello,
I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query?
Thanks (2 Replies)
Discussion started by: kingluke
2 Replies
3. Shell Programming and Scripting
Hi all,
I would want to spool file for a database query, however by using crontab, the file is not spooled. Below shows my script:
ORACLE_HOME="/u01/oraprod/perpdb/10.1.0/db_1"
OUTFILE="/tmp/invalid.out"
FILE="$HOME/admin/scripts"
$ORACLE_HOME/bin/sqlplus -s "/as sysdba"... (0 Replies)
Discussion started by: *Jess*
0 Replies
4. Programming
Is there anyway to spool my select statement into spool files of max 10000 records each?
eg I have a select statement that will return 45000 records.
A normal spool command will output the 45000 into just one spool file.
How can I make sqlplus do this?
00001 - 10000 records --- spool... (3 Replies)
Discussion started by: Leion
3 Replies
5. Shell Programming and Scripting
for diskname in $(lspv |awk '{print $1}')
do
lquerypv -h /dev/|awk '/'$diskname'/ { print ; exit }'
done
No output is returning from the loop.
I think awk put an extra space to the command - lquerypv -h /dev/
so that the command is executed as i.e. lquerypv -h /dev/ hdisk230 with a space... (7 Replies)
Discussion started by: Daniel Gate
7 Replies
6. Shell Programming and Scripting
I have used m4 in the past to generate source code where aesthetics and space were of no consequence . Now I am using it to generate script and program templates .
So here is an excerpt from my m4 file for producing a generic bash script:
dnl `$Id$'
define(`START_SCRIPT',`#!/bin/bash... (8 Replies)
Discussion started by: Bubnoff
8 Replies
7. Shell Programming and Scripting
Hi,
Since today, with csh or tcsh, if I do 'ls files* > list',
every lines end with an extra space!
What happenned?
What can I do to go back when there was no extra space?
If I change to bash, there's no extra space.
Thanks,
Patrick
---------- Post updated at 03:19 PM... (1 Reply)
Discussion started by: trogne
1 Replies
8. Shell Programming and Scripting
Hi Gurus,
I have a file which contains some special char or space.
when using cat -evt I can see the file as following:
0,"0000","abc/def aaa ... (6 Replies)
Discussion started by: ken6503
6 Replies
9. Shell Programming and Scripting
Hi All,
Im trying to find the count of process running on remote server using SSH.
Below command dosen't work.
ssh -q user@host "ps -ef | grep "pattern" | grep -v 'grep' | awk '{print $2}'|wc -l"
But below command works.
ssh -q user@host "ps -ef | grep "pattern" | grep -v... (1 Reply)
Discussion started by: Girish19
1 Replies
10. Shell Programming and Scripting
Hi All
I am trying to perform the below operation -count=`cat abc.txt | wc -l`
echo$count
5
Head=Start"$DATE"00000"$count"File
echo $HEAD
START15020300000 5File
There is a space coming before 5 which is not needed . How to ignore that . (4 Replies)
Discussion started by: honey26
4 Replies
LEARN ABOUT ULTRIX
uupoll
uuaids(8c) uuaids(8c) Name uucompact, uumkspool, uurespool, uupoll - uucp utilities Syntax uucompact -ssystem uumkspool system ... uurespool [ -t# ] uupoll system ... Description All of the commands are located in The command compacts uucp system spool directories and associated subdirectories. If system is ALL, then all existing uucp system spool directories are compacted. Otherwise, only the specified system spool directory is compacted. If no system is specified, is compacted. If is stopped before it is finished, it can be restarted without reprocessing directories. The command continues processing where it left off during it's previous instantiation. The command makes a per system spool directory and associated subdirectories for each of the specified systems. For example, if system is mk3 and if the local system name is penny, the following directories are created: /usr/spool/uucp/sys/mk3 /usr/spool/uucp/sys/mk3/C. /usr/spool/uucp/sys/mk3/X. /usr/spool/uucp/sys/mk3/D. /usr/spool/uucp/sys/mk3/D.penny /usr/spool/uucp/sys/mk3/D.penny The command moves files from old spool directories to new spool directories. Because the structure of the spool directories has changed from older versions of it is necessary to respool old spooled files to new spool directories in at least two instances: o When installing the current version of o When creating a new system spool directory for each system. In the latter case, it is necessary to move files from to the new spool directories. To ease this task, moves files that have been spooled in one of 4 formats and respools them under the new spooling structure. The format is specified by the -t# option, where the number sign (#) can be any one of the following: o Original spool - All files are in o Split spool - Contains the subdirectories o Modified split spool - Contains all subdirectories listed in split spool, and o Used when a new system directory has been created and spool files must be moved from the DEFAULT directory to the new system directory. The command forces a connect attempt to the named systems even if recent attempts have failed, but not if the file prohibits the call. For example, the file will prohibit the call if it is the wrong time of day. Thus, the should be monitored for messages about the connection. Files Spool directory Logfile See Also mail(1), uucp(1c), uux(1c) uuaids(8c)