https://ittichaicham.com/wiki/index.php?action=history&feed=atom&title=Oracle_APEX_backups_via_command_line%2Fscript 2026-10-15T21:48:01Z Revision history for this page on the wiki MediaWiki 1.34.2 https://ittichaicham.com/wiki/index.php?title=Oracle_APEX_backups_via_command_line/script&diff=942&oldid=prev 2013-06-30T03:24:25Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 03:24, 30 June 2013</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l10" >Line 10:</td> <td colspan="2" class="diff-lineno">Line 10:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>set USER=dbuser</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>set USER=dbuser</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>set PWD=dbpassword</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>set PWD=dbpassword</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"># For Workspace backup</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>set WORKSPACEID=1260432179363693</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>set WORKSPACEID=1260432179363693</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"># For App backup</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>set APPID=131</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>set APPID=131</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> </table>

Ittichai https://ittichaicham.com/wiki/index.php?title=Oracle_APEX_backups_via_command_line/script&diff=941&oldid=prev 2013-06-30T03:23:12Z

<p>Created page with &quot;The APEX installation files are required. http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html * Windows &lt;pre&gt; set DRIVE=F: set ORACLECLASSPATH=D:\app\pr...&quot;</p> <p><b>New page</b></p><div>The APEX installation files are required.<br /> http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html<br /> <br /> * Windows <br /> &lt;pre&gt;<br /> set DRIVE=F:<br /> set ORACLECLASSPATH=D:\app\product\11.2.0\client_1\jdbc\lib\ojdbc6.jar<br /> set UTILITYPATH=F:\Download\apex_4.2.2\apex\utilities<br /> set DBHOST=il02dwdev1.comm.mot.com:1521:DEDW<br /> set USER=dbuser<br /> set PWD=dbpassword<br /> set WORKSPACEID=1260432179363693<br /> set APPID=131<br /> <br /> %DRIVE%<br /> cd %UTILITYPATH%<br /> <br /> set CLASSPATH=%CLASSPATH%;%ORACLECLASSPATH%;%UTILITYPATH%<br /> <br /> # Backup every Apps owned by USER<br /> # If USER is APEX_040200 or SYSTEM, this will backup EVERY apps<br /> java oracle.apex.APEXExport -db %DBHOST% -user %USER% -password %PWD% -instance<br /> <br /> # Backup all Apps in a workspace<br /> java oracle.apex.APEXExport -db %DBHOST% -user %USER% -password %PWD% -workspaceid %WORKSPACEID%<br /> <br /> # Backup only an App<br /> java oracle.apex.APEXExport -db %DBHOST% -user %USER% -password %PWD% -applicationid %APPID%<br /> <br /> &lt;/pre&gt;<br /> <br /> [[Category:Oracle APEX]]</div>

Ittichai