You will have to write a PL/SQL code block that fetches rows, opening a new file and closing the old file every 1000 rows. Use the UTL_FILE file package.
A much simpler way to do this is to call the unix split command
Split seems good but what if the sql returned too many rows and the size of the spool file may go beyond the max file size ?
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)
Hi,I have a single sql file containing many create table ddl's.Example:
CREATE TABLE sec_afs
(
rpt_per_typ_c char(1) NOT NULL,
rpt_per_typ_t varchar(20) NULL,
LOCK ALLPAGES
go
EXEC sp_primarykey 'sec_afs', rpt_per_typ_c
go
GRANT SELECT ON sec_afs TO developer_read_only... (5 Replies)
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Hi,
I will use below command for grep single string ("osuser" is search string)
ex: find . -type f | xarg grep -il osuser
but i have one more string "v$session"
here i want to grep in which file these two strings are present.
any help is appreciated,
Thanks in advance.
Gagan (2 Replies)
Hi,
I'm trying to build a shell script that reads a set of accounts from a file. For each account I need to perform a set of sql queries. So I have a loop with a set of sqlplus connections to retrieved my data.
Is it possible to have a single sqlplus connection before entering the loop and... (4 Replies)
I want to spool files from unix using a sql script that would
take values from another sql query within the KSH script..
unix loop
select order_date from date_tbl
for each order_Date i need to call this spool script with the value
sqlplus scott/tiger@order_db @/ordspool/order_date.sql... (2 Replies)
Hi,
Im writing a script to run a bit of sql(via sqlplus) that pulls back some data and spools it to a file, I want the spool file to only display the data, with no sql command at the top and no reports at the bottom ie(# of records recieved).
I am currently doing it via a grep command but... (1 Reply)
Hi all ,
I want to pass contents from a file say f1 as arguments to a sql query which has In statement using a script
example
select * from table_1 where login in ( `cat f1`) ;
will this work or is there any other way to do it. (1 Reply)
Dear All,
I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File.
The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files.
Any... (14 Replies)
Discussion started by: Rahul_Bhasin
14 Replies
LEARN ABOUT XFREE86
receive
RECEIVE(1) General Commands Manual RECEIVE(1)NAME
receive - receive files from the sendfile spool
SYNOPSIS
receive [ -d ] [ -r ] [ -k ] [ -P ] [ -S ] [ -Z spool ] [ -q ] [ -ffrom ] file [...]
receive -n [ -d ] [ -r ] [ -k ] [ -P ] [ -S ] [ -Z spool ] [ -q ] file-number [...]
receive [ -s ] [ -l ] [ -L ] [ -R ] [ -ffrom ]
receive -b user[@host] [ -k ] [ -f"from" ] file [...]
receive -b user[@host] [ -k ] [ -f"from" ] -n file-number [...]
receive -b user[@host] [ -k ] -a
DESCRIPTION
receive files from the sendfile spool which has been sent to you.
If there is already a file with the same name you will be prompted for overwriting or renaming.
Allowed wildcards in file names are: * ? [abc] [^abc]
CAUTION: you have to put wildcards and other special characters in '' quotes to hide them for interpretation by your shell.
OPTIONS -n receive file number(s)
-d delete instead of receive
-a receive (or delete or bounce) all files
-r rename before receiving
-k keep files in spool after receiving
-P pipe files to stdout
-S receive only pgp-signed files
-s list files in short format
-l list files
-L list files and look inside archives, too
-R renumber files in spool
-b bounce (forward) files to another recipient
-q quiet mode: no questions asked
-fuser all actions refer only to files from this user
-Z spool
specify an alternate spool directory
EXAMPLES
receive -L
list all files in long format.
receive 'blubb*'
receive all files starting with string "blubb".
receive -daf microsoft.com
delete all files from microsoft.com sites.
receive -b framstag@bofh '*.jpg'
bounce all *.jpg-files to framstag@bofh.
FILES
/var/spool/sendfile The sendfile spool directory.
/var/spool/sendfile/$USER/log
A log of the last transfers.
/etc/sendfile.deny Users which are not allowed to receive files or messages (set by root).
SEE ALSO sendfile(1).
AUTHOR
Ulli Horlacher - framstag@rus.uni-stuttgart.de
3rd Berkeley DistributionRECEIVE(1)