Oracle APEX backup script for Windows

From Ittichai Chammavanijakul's Wiki
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%