Comments
| Oracle Shell Scripting - This article presents some some basic techniques for creating Windows batch files and UNIX/Linux shell scripts that connect to SQL*Plus and RMAN. |
William Robertson said... Possibly the title "Oracle Shell Scripting" might lead some people to expect an article about shell scripting around Oracle in general as a tool for application development (which, as I'm always ranting on about, I believe to be bad and wrong) rather than RMAN specifically, for which it is well suited. |
Márcio said... Very good.....thanks |
Lori said... The examples were simple and clear. Excellent. Thank you. |
Fer said... Good example..thanks |
rash said... simple and to the point...thanx..:). |
Tugg said... Great information...it was a big help. Finding this sooner would have saved me a couple early morning hours. |
varun dhawan said... Awsome !!among dozen of other webpages, only this page has helped my in resolving my issue. Truely ROCKING !! |
Ranbir Kaur said... Perfect! Helped me alot to take hot/cold backup...thanx alot! |
Tony said... Thank you for your good work at oracle-base.com, it is very helpful.There is a way to redirect a SQL script from a Windows CLI script without using a stored SQL script. The caret sign '^' is used as ESCape character. I'm referring to following example I've posted on OTN forum: set ORACLE_SID=ORCL ( echo WHENEVER SQLERROR EXIT SQL.SQLCODE failure rollback echo connect / as sysdba echo spool redirect_conTEXT_logfile_%ORACLE_SID%.log echo set lines 140 pages 50 trimspool on echo col par_name format a35 echo col par_value format a45 echo prompt *** Current Oracle Text ^^^(CONTEXT^^^) LOG directory ***; echo prompt; echo SELECT par_value, par_name FROM ctx_parameters echo WHERE par_name='LOG_DIRECTORY'; echo prompt execute ctxsys.CTX_ADM.SET_PARAMETER ^^^('LOG_DIRECTORY', - echo 'F:\oracle\admin\%ORACLE_SID%\context\log'^^^); echo prompt *** NEW Oracle Text LOG directory ***; echo prompt; echo SELECT par_value, par_name FROM ctx_parameters echo WHERE par_name='LOG_DIRECTORY'; echo spool off echo exit ) | sqlplus /nolog echo %ERRORLEVEL% |
Lawrence cumber said... Very Direct. That was a very good example. |
anandkarya said... It is very nice and helpful for all the learner and new in oracle industry. I appreciate you for this. |
DO NOT ask technical questions here, that's what my forum is for!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!