Difference between revisions of "Oracle APEX backups via command line/script"
Jump to navigation
Jump to search
(Created page with "The APEX installation files are required. http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html * Windows <pre> set DRIVE=F: set ORACLECLASSPATH=D:\app\pr...") |
|||
Line 10: | Line 10: | ||
set USER=dbuser | set USER=dbuser | ||
set PWD=dbpassword | set PWD=dbpassword | ||
+ | # For Workspace backup | ||
set WORKSPACEID=1260432179363693 | set WORKSPACEID=1260432179363693 | ||
+ | # For App backup | ||
set APPID=131 | set APPID=131 | ||
Latest revision as of 22:24, 29 June 2013
The APEX installation files are required. http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html
- Windows
set DRIVE=F: set ORACLECLASSPATH=D:\app\product\11.2.0\client_1\jdbc\lib\ojdbc6.jar set UTILITYPATH=F:\Download\apex_4.2.2\apex\utilities set DBHOST=il02dwdev1.comm.mot.com:1521:DEDW set USER=dbuser set PWD=dbpassword # For Workspace backup set WORKSPACEID=1260432179363693 # For App backup set APPID=131 %DRIVE% cd %UTILITYPATH% set CLASSPATH=%CLASSPATH%;%ORACLECLASSPATH%;%UTILITYPATH% # Backup every Apps owned by USER # If USER is APEX_040200 or SYSTEM, this will backup EVERY apps java oracle.apex.APEXExport -db %DBHOST% -user %USER% -password %PWD% -instance # Backup all Apps in a workspace java oracle.apex.APEXExport -db %DBHOST% -user %USER% -password %PWD% -workspaceid %WORKSPACEID% # Backup only an App java oracle.apex.APEXExport -db %DBHOST% -user %USER% -password %PWD% -applicationid %APPID%