04-07-2008
To spool output from a database query
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" @$FILE/compile_inv_obj.sql
sleep 30
echo exit >>$FILE/comp_all.sql
contents inside $FILE/compile_inv_obj.sql
spool comp_all.sql
select
decode( OBJECT_TYPE, 'PACKAGE BODY',
'alter package ' || OWNER||'.'||OBJECT_NAME || ' compile body;',
'alter ' || OBJECT_TYPE || ' ' || OWNER||'.'||OBJECT_NAME || ' compile;' )
from
dba_objects
spool off
I could not c comp_all.sql in anywhere of my file system. Any suggestions would be much appreciated. Thanks!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi friends,
I have written a script which retrieves one value from the database.
It takes time for the sql query to get the desired output. So the query runs fine from TOAD or from UNIX console.
However if I put this in a script it doesn't work. The script is as below.
#! /bin/ksh... (2 Replies)
Discussion started by: vivek_damodaran
2 Replies
2. Shell Programming and Scripting
Hi,
Am using informix database. When i give "isqlrf <database name> - " from the command prompt , i get connected to the database and i can run sql queries..
I am moving to freeBSD and when i give the same command at the prompt i get an error : Index already exists on column
Why is this... (0 Replies)
Discussion started by: jisha
0 Replies
3. 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
4. Shell Programming and Scripting
I would like to use the result of a query in another query. How do I redirect/add the output to another variable?
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result)) {
echo $row,"\n";
}
odbc_close($connect);
?>
This will output hostnames:
host1... (0 Replies)
Discussion started by: hazno
0 Replies
5. Shell Programming and Scripting
Hi,
I'm creating a shell script to dynamically create a recreate controlfile for an Oracle database. I need to read a cold backup file system, and make some changes to these files.
Let's say for argument sake the directory name is /ebsprod_c/oradata and it looks like this:... (6 Replies)
Discussion started by: exm
6 Replies
6. Shell Programming and Scripting
Hi All,
I am spooling the data some sql queries into a single file but wanted to know how to format the data of the file generated by spool.
#!/bin/sh
unset -f USAGE
USAGE () {
clear
echo "############################USAGE#######################\n"
echo "Incorrect number of... (2 Replies)
Discussion started by: ss_ss
2 Replies
7. Shell Programming and Scripting
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
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)
Discussion started by: Magezy
1 Replies
9. UNIX for Dummies Questions & Answers
Hello,
I have a requirement where i have to spool some data to a file. i have achived the desired target but m facing one issue. i have attached the script and the output.
i checked the data length in the table but it is only 45 for column 1.
can you tell me how to remove these extra... (4 Replies)
Discussion started by: Mohammed_Tabish
4 Replies
10. Programming
I am getting an error function in date formate while importing the date ccolumn in oracle sql developer tool
My date format in table is 6-Nov-14 and while importing its converted to 6/11/14 eventhough the format is as 6-Nov-14 in excel.
could you please let help me out what I need to change... (6 Replies)
Discussion started by: ramkumar15
6 Replies
LEARN ABOUT DEBIAN
bcrontab
bcrontab(1) General Commands Manual bcrontab(1)
NAME
bcrontab - Manage users crontab files
SYNOPSIS
bcrontab [ -u user ] file
bcrontab [ -u user ] { -l | -r | -e }
DESCRIPTION
bcrontab interfaces with the bcron-spool daemon to manage crontab files in the privileged spool directory.
OPTIONS
-u user
Tell bcron-spool that we are acting on behalf of the named user. bcron-spool will only accept the username if bcrontab is running
as either root or the same user ID as the named user.
-l List the cronab crontab to standard output.
-r Remove the user's crontab.
-e Edit the current crontab.
ENVIRONMENT
VISUAL If this is set, it is used as the editor to invoke to edit a crontab.
EDITOR If $VISUAL is not set and this is, it is used as the editor to invoke to edit a crontab. If neither are set, /bin/vi is used.
BCRON_SOCKET
The path to the named socket used to communicate with bcron-spool. Defaults to /var/run/bcron-spool.
LOGNAME
USER These two variables are used, in order, to determine the user name invoking the program. One must be set if the -u option is not
used.
FILES
bcrontab tries to writes a temporary file into the current directory, and then into /tmp if that fails, in order to edit the current
crontab.
SEE ALSO
bcron-spool(8), crontab(5)
AUTHOR
Bruce Guenter <bruceg@em.ca>
bcrontab(1)