This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallAnywhere
- :
- InstallAnywhere Forum
- :
- Re: Executing an oracle script in IA
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 10, 2010
09:05 AM
Executing an oracle script in IA
Hi,
I've just started using IA 2008, and need to update our custom oracle installer to run the following commands:
C:\>sqlplus sys/password as sysdba
SQL>EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
SQL>PURGE DBA_RECYCLEBIN;
SQL>exit
Can someone please let me know what's the best way to do this? Should I add all of these as separate execute command actions, or put all of the commands in a file and use the execute script/batch file to run them.
Thanks in advance, any help will be much appreciated.
I've just started using IA 2008, and need to update our custom oracle installer to run the following commands:
C:\>sqlplus sys/password as sysdba
SQL>EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
SQL>PURGE DBA_RECYCLEBIN;
SQL>exit
Can someone please let me know what's the best way to do this? Should I add all of these as separate execute command actions, or put all of the commands in a file and use the execute script/batch file to run them.
Thanks in advance, any help will be much appreciated.
(3) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 10, 2010
09:15 AM
I think both approaches should work.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 10, 2010
09:28 AM
Thanks.. my only doubt with putting all of these as separate commands was that the commands:
SQL>EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
SQL>PURGE DBA_RECYCLEBIN;
SQL>exit
are not really commands you can directly enter in a command window, will they still be executed correctly since I'm connecting to sqlplus in the previous command?
If I put all of these in a file, do I use it as a batch file and include it in IA? or add them as scripts?
SQL>EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
SQL>PURGE DBA_RECYCLEBIN;
SQL>exit
are not really commands you can directly enter in a command window, will they still be executed correctly since I'm connecting to sqlplus in the previous command?
If I put all of these in a file, do I use it as a batch file and include it in IA? or add them as scripts?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 10, 2010
10:08 AM
Sorry, I missed that (i.e. that those 3 are commands written at the SQL prompt). I think you don't have any choice but put that into an .SQL script.