Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: SQLPlus spool file
Top Forums UNIX for Dummies Questions & Answers SQLPlus spool file Post 302260618 by vbe on Friday 21st of November 2008 08:29:59 AM
Old 11-21-2008
Have you just an idea of the size of the file?...
What is the point?
You will have quite some trouble looking at it with vi...
Where is this file written? do you have to be safe >3GB free there?
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Increase width of Spool file

Hi All This may not be entirely Unix related but I'll just have to try my luck and see if you know how to do this: I need to spool the results of my SQL query into a file but as there are too many fields in the query the resultant spool file put the last few fields on the next line. May I... (2 Replies)
Discussion started by: handynas
2 Replies

2. Shell Programming and Scripting

code to FTP the spool file from Sqlplus to the unix server.

I have a sqlplus report and inside that report I have the following piece of code to mail the report output to the email id. My requirement is, instead of emailing the output I want to FTP that script to a different unix server (say ip as 10.10.1.1). How to modify this code to FTP the spool file... (0 Replies)
Discussion started by: vprevin
0 Replies

3. Shell Programming and Scripting

how to spool a unix file

hi, can anyone help me by saying how can i spool a unix file.. do we need to specify the pathname as such to spool the file .. right now, i tried giving like spool filename in the sql prompt.. but its not giving me the required output even if i can see that the command is being executed.. ... (2 Replies)
Discussion started by: kripssmart
2 Replies

4. AIX

Spool data file

Dear Gurus, Tried searching for some clues in this forum but dont seem to be able to find my answer. :confused: Anyway i have a quick question: Today I have produced a messages generated from a application and placed them on the print queue. Before this I had stopped the printer queue, so... (2 Replies)
Discussion started by: lweegp
2 Replies

5. Shell Programming and Scripting

Problem in spool file

Hi, Iam a newbie. When I give the below query at SQL prompt. SQL> select col1||'`ß`'||col2 from tablename where rownum<2; 1-J7WGX`ß`1-7OKC-23 Iam getting ß within appostropies...... If I remove appostropies and give the query it is throwing an error. If I give the same query in spool as... (1 Reply)
Discussion started by: kknayak
1 Replies

6. Shell Programming and Scripting

spool to file in ksh

hi all, am trying to write a ksh script which will take a username, password, db instance as input arguments and login to the database using sqlplus and select some data via sql and spool to a file. problem is that i am using "sqlplus -s" in order to hide the username/password and it doesnt... (8 Replies)
Discussion started by: cesarNZ
8 Replies

7. Shell Programming and Scripting

Help supressing spool output from screen when calling sqlplus from script

I'm calling an embedded sql from my shell script file. This sql does simple task of spooling out the contents of the table (see below my sample code) into a spool file that I specify. So far so good, but the problem is that the output is also displayed on screen which I do NOT want. How can I... (3 Replies)
Discussion started by: MxC
3 Replies

8. Shell Programming and Scripting

Spool Data in a file

Hello, I am trying to spool data from database into a file on solaris through ksh. Data is getting fetched but the problem is record is getting split in to multiple lines. excerpt from sql is whenever sqlerror exit 1; set define on set echo off set feed off set head off set... (1 Reply)
Discussion started by: abhi1988sri
1 Replies

9. Shell Programming and Scripting

Sqlplus error - sqlplus -s <login/password@dbname> : No such file or directory

i am using bash shell Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127. IFS="," declare -a Arr=($Variable1); SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE} echo "set head off ; " > ${SQLCMD} echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies

10. Shell Programming and Scripting

Spool file requirement

Hi, I have a requirement of Connecting to sqlplus from unix Execute the package. The output of package is stored in a table Need to query the table and move to txt file. The problem iam facing is, when I try to spool the file. I get the sql query also along with the output.... (6 Replies)
Discussion started by: Shanmugapriya D
6 Replies

LEARN ABOUT DEBIAN

faxabort

FAXABORT(8)						      System Manager's Manual						       FAXABORT(8)

NAME

       faxabort - tell a HylaFAX server to abort a receive

SYNOPSIS

       /usr/sbin/faxabort [ -q dir ] modem

DESCRIPTION

       faxabort sends a message to a HylaFAX faxgetty(8) process servicing modem telling it to abort any active receive operation.

       The  specified  modem can either be the name (typically the last component of the terminal port the modem is attached to), or the full name
       of the associated FIFO named pipe file, e.g. ``FIFO.ttym2''.

       Note that to abort a send operation the faxrm(1) command must be used.

OPTIONS

       -q dir	 Use a spooling area other than /var/spool/hylafax.

NOTES

       On some systems it is not possible to abort a received facsimile because of problems in the operating system; on such systems  the  message
       sent by faxabort will be (silently) ignored.

FILES

       /var/spool/hylafax		  default spooling area
       /var/spool/hylafax/FIFO		  fifo for contacting faxq

       Consult hylafax-server(5) for a complete discussion of the structure and content of the spooling area.

SEE ALSO

       hylafax-server(5), faxq(8), faxgetty(8)

								   March 3, 1995						       FAXABORT(8)
All times are GMT -4. The time now is 12:15 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy