Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

To spool output from a database query

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting To spool output from a database query
# 1  
Old 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!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

Database query

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

2. UNIX for Dummies Questions & Answers

#Spool/Query executing with extra space.

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

3. Shell Programming and Scripting

SQL*PLUS Spool Output

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

4. 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

5. Shell Programming and Scripting

manipulate & format the output of spool command

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

6. Shell Programming and Scripting

Need help with a sh script to spool directory and modify the output (Oracle cnt file)

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

7. Shell Programming and Scripting

add the output of a query to a variable to be used in another query

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

8. Programming

Single sql query to spool to multiple files

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

9. Shell Programming and Scripting

Database Query

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

10. Shell Programming and Scripting

query to get a value from database

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
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

snprimedb

snprimedb,v0.3.8(8)					      System Manager's Manual					       snprimedb,v0.3.8(8)

NAME

       snprimedb - feed the sn database.

SYNOPSIS

       snprimedb [-i] (no arguments)

DESCRIPTION

       snprimedb reads records from its standard input and enters them into the database.  The database is appended to; if you want to start a new
       database, you would delete the database files .chain, .table, .newsgroup before running this program.

       The main purpose of snprimedb is to rebuild the ID database.  Then its input is usually obtained from snscan.

       If the option -i is given, simply initialize the database files if they do not exist, and exit.

       Input lines are of the format
       newsgroup id serial where newsgroup is the newsgroup the article may be found in, id is its message id, and serial is the local serial num-
       ber of that article in that newsgroup.  If newsgroup is the special name =junk, then the whole line is ignored.

       You will need to be root or the owner of /var/spool/sn to do this.

BUGS

       snprimedb does not check to see that the articles really exist.	Also the size of the hash table is fixed at compile time.

       Under  degenerate conditions, the hash table file .chain (see below) could grow very large, with reclaimed space remaining unused.  This is
       due to the very simple file space allocator, which doesn't know how to coalesce adjacent free areas.  It doesn't know  how  to  split  them
       either.	The allocator assumes that the shape of the distribution of record lengths remains quite constant over time.

       The hash table database doesn't make any attempt to reduce its footprint.  This should be acceptable, since the database is shared.

ENVIRONMENT VARIABLES

       SNROOT If this is set and is not empty, the value is used in place of /var/spool/sn, the default news spool directory.

FILES

       /var/spool/sn/.table
	      snprimedb uses this file as the index of the hash table, and ...

       /var/spool/sn/.chain
	      as the hash chains, and ...

       /var/spool/sn/.newsgroup
	      to attach an integer identifier to each newsgroup name.  This file is a human-readable flat text file.

N.B.								    Harold Tay						       snprimedb,v0.3.8(8)