Difference between revisions of "Oracle APEX backup script for Windows"
Jump to navigation
Jump to search
(Created page with "<pre> Download APEX 4.2.2 from http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html set DRIVE=F: set ORACLECLASSPATH=D:\app\product\11.2.0\client_1\jdbc\...") |
|||
Line 29: | Line 29: | ||
# Backup only an App | # Backup only an App | ||
java oracle.apex.APEXExport -db %DBHOST% -user %USER% -password %PWD% -applicationid %APPID% | java oracle.apex.APEXExport -db %DBHOST% -user %USER% -password %PWD% -applicationid %APPID% | ||
+ | |||
+ | </pre> | ||
+ | |||
+ | [[Category:APEX]] |
Latest revision as of 11:45, 23 July 2013
Download APEX 4.2.2 from http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html 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=host:1521:db # Change environment variables as needed # Either APEX_040200 or workspace schema user set USER=wkspace_apex set PWD=password # If export by workspace or app ID set WORKSPACEID=1260432179363693 set APPID=131 %DRIVE% cd %UTILITYPATH% set CLASSPATH=%CLASSPATH%;%ORACLECLASSPATH%;%UTILITYPATH% # 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%