For this reason, I suggest you exiting with a good return status different from 0, and test this value for successful completion of the sql script.
Every exit status is good, only dont' use 0
Here at work we have a whole bunch of sql programs made in this way for avoiding this problem.
He's using whenever sql/os error, so if
there is a SQL, PL/SQL or OS error, it's handled before the final exit:
It's about the syntax errors that are not handled by the whenever directive.
Hi ,
I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script
Right now no file is generated on the unix box...it is a... (2 Replies)
I have a script which connects to different database servers using sqlplus. Is there a way by which I can run a shell command on that host from sqlplus?
I know about 'host' command but it runs script on the local machine where the original script is running. Is there a way to run command on the... (9 Replies)
Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files..
Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this?
Please tell me... (2 Replies)
Hi,
I am writing a script to test database connection. If the first try fails, it will wait for 1 minutes and then try again. The script is as following:
........
for i in $ORACLE_SID
do
$ORACLE_HOME/bin/sqlplus $username/$password@$i <<! >/dev/null
select * from tab;
exit
if ; then... (3 Replies)
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Hi
I want to connect to the Oracle database using a username/password and get back the query result(a numeric value) in a variable, which I can then compare using a conditional.
Can anybody help me with this.
Thanks
Gaurav (4 Replies)
Hi All,
How i will use sqlplus in shell script?
Can any one provide sample code which explain following:
1. Connect to oracle DB
2. Exceute select * from tablename
3. Release connection to the DB
4. Append output in file everytime when query executes.
Thanks in advance (1 Reply)
sql_rows=`sqlplus -s / <<EOF
set heading off
set pagesize 1000
set tab off
set linesize 120 wrap off
column "Path" format a15
--column "No_Of_files" format a10
select tablespace_name, substr(file_name,1,instr(file_name,'/',1,2)) as "Path" , count(*) as "No_Of_files" from dba_data_files
... (7 Replies)
Hi All,
Please let me know what i am missing in the following code (part of my script)
Schemas=(AWQM WFCONTROLLER PROVCO PRISM)
for s in "${Schemas}"
do
sch="${s}_$tol"
if || ;then
echo "This is AD or TD region"
sqlplus -s $sch/$tpwd@$ttns <<EOF... (7 Replies)
Discussion started by: pvmanikandan
7 Replies
LEARN ABOUT DEBIAN
dspam_maintenance
dspam_maintenance(1) User Commands dspam_maintenance(1)NAME
dspam_maintenance - remove old signatures and unimportant tokens from the DSPAM storage backend
SYNOPSIS
dspam_maintenance [--profile=PROFILE] [--logdays=no_of_days] [--signatures=no_of_days] [--neutral=no_of_days] [--unused=no_of_days]
[--hapaxes=no_of_days] [--hits1s=no_of_days] [--hits1i=no_of_days] [--without-sql-purge] [--with-sql-automatization] [--with-sql-autoup-
date] [--purgescriptdir=directory] [--with-all-drivers] [--verbose]
DESCRIPTION
dspam_maintenance is used to remove old signatures/tokens and unimportant tokens from the DSPAM storage backend and purge old log entries
in user and system logs.
This script can be called from the command line or run from within cron. Either add a line in your crontab or add this script in your
cron.{hourly,daily,weekly,monthly}. Running this script every hour might not be the best idea but it's your decision if you want to do so.
OPTIONS --profile=PROFILE
Specify a storage profile from dspam.conf. The storage profile selected will be used for all database connectivity.
NOTE: See dspam.conf for more information.
--logdays=no_of_days
All log entries older than no_of_days days will be removed.
NOTE: Default is 31 days. (for more info: man dspam_logrotate)
--signatures=no_of_days
All signatures older than no_of_daysdays will be removed.
NOTE: Default value is set by the PurgeSignatures option in dspam.conf, if this option is not set, the default value is 14 days.
This option is only used for the Hash driver.
--neutral=no_of_days
Deletes all tokens from the target users database whose probability is between 0.35 and 0.65 (fairly neutral, useless data).
NOTE: Default value is set by the PurgeNeutral option in dspam.conf, if this option is not set, the default value is 90 days.
--unused=no_of_days
Remove stale tokens which have not been used for a long period of time.
NOTE: Default value is set by the PurgeUnused option in dspam.conf, if this option is not set, the default value is 90 days.
--hapaxes=no_of_days
Remove tokens with a total hit count below 5 (which will be assigned a hapaxial value by DSPAM).
NOTE: Default value is set by the PurgeHapaxes option in dspam.conf, if this option is not set, the default value is 30 days.
--hits1s=no_of_days
Remove tokens with a single SPAM hit.
NOTE: Default value is set by the PurgeHits1S option in dspam.conf, if this option is not set, the default value is 15 days.
--hits1i=no_of_days
Remove tokens with a single INNOCENT hit.
NOTE: Default value is set by the PurgeHits1I option in dspam.conf, if this option is not set, the default value is 15 days.
--without-sql-purge
Do not use SQL based purging. Only run dspam_clean.
NOTE: Default is off (aka: use SQL based purging).
--with-sql-optimization
Run VACUUM (for PostgreSQL/SQLite) and/or OPTIMIZE (for MySQL).
NOTE: Default is off (aka: do not use optimizations).
--with-sql-autoupdate
Run SQL based purging with purge day values passed to dspam_maintenance.
NOTE: Default is off (aka: do not attempt to modify SQL instructions).
--purgescriptdir=directory
Space separated list of directories where to search for SQL files used for the SQL based purging.
--with-all-drivers
Process all installed storage drivers (not just the active driver).
NOTE: Default is true (aka: process all installed drivers).
--verbose
Verbose output while running maintenance script.
EXIT VALUE
0 Operation was successful.
other Operation resulted in an error. Run the script with --verbose to get more information about error.
COPYRIGHT
Copyright (C) 2002-2010 DSPAM Project
All rights reserved.
For more information, see http://dspam.sourceforge.net.
SEE ALSO dspam(1), dspam_admin(1), dspam_clean(1), dspam_crc(1), dspam_dump(1), dspam_logrotate(1), dspam_merge(1), dspam_stats(1), dspam_train(1)dspam_maintenance Apr 26, 2010 dspam_maintenance(1)