Oracle APEX backups via command line/script

From Ittichai Chammavanijakul's Wiki
Jump to navigation Jump to search

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%
Retrieved from "https://ittichaicham.com/wiki/index.php?title=Oracle_APEX_backups_via_command_line/script&oldid=942"