How to export and import oracle apex application and workspace from command line

Query to identify applications/workspace information of your Oracle apex Application

COLUMN workspace FORMAT A20
COLUMN workspace_id FORMAT 99999999999999999999
COLUMN application_id FORMAT A14
COLUMN application_name FORMAT A20

— List applications.
SELECT workspace,
workspace_id,
application_id,
application_name
FROM apex_applications
ORDER BY 1;

Export the Apex Application:

1.Set environment variables to execute java APEXExport utility

export JAVA_HOME=/u01/dbebs/EBSDB/db/tech_st/11.2.0.4/jdk/jre/bin
export ORACLE_HOME=/u01/dbebs/EBSDB/db/tech_st/11.2.0.4
export CLASSPATH=.:${ORACLE_HOME}/jdbc/lib/ojdbc6.jar

2. Go to apex utilities directory

cd /u01/app/apex_18_2/apex/utilities

Full Workspace Export,

java oracle.apex.APEXExport -db <db_server_IP>:<portno>:<sid> -user <schema_name> -password <password> -workspaceid <workspace_id>

java oracle.apex.APEXExport -db 172.14.0.32:1527:EBSDB -user ics -password ics@123 -workspaceid 36588308235771

Single Application export,

java oracle.apex.APEXExport -db <db_server_IP>:<port_no>:<sid> -user <schema_name> -password <password> -applicationid <application_id>

java oracle.apex.APEXExport -db 172.14.0.32:1527:EBSDB -user ics -password ics@123 -applicationid 123

Now copy the files to server where you need to import

Import the Apex Application:

1. Set env to connect to database

export ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1
export ORACLE_SID=SOD

2. Import the .sql file
conn sod_ics/si@357
@f123.sql;