|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Database Query | jisha | Shell Programming and Scripting | 0 | 01-22-2008 03:13 AM |
| query to get a value from database | vivek_damodaran | Shell Programming and Scripting | 2 | 12-17-2007 01:20 PM |
| Dynamic update loop query on Sybase database | Alaeddin | Shell Programming and Scripting | 10 | 12-13-2007 06:26 AM |
| storing database query in a variable | debu | Shell Programming and Scripting | 3 | 11-25-2007 07:59 PM |
| HTTP Query Request & Parsing returned XML output | jerardfjay | Shell Programming and Scripting | 15 | 05-18-2005 10:25 AM |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
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! |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode
