Oracle APEX backup script for Windows
Jump to navigation
Jump to search
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%