Preparation

Schema Migration

To Migrate a Schema used by an APEX application from one Database Instance to another...

• Create target tablespace(s) for the application tables

• Use DataPump to duplicate the Schema(s) supporting the application

Identify Workspaces

Identify Applications

APEXExport

Unless you are exporting from a different instance, all variables except APXAPP and APXSYS should be set in your .profile.

export APXHST=$(hostname -s)      # Hostname of Source database

export APXPRT=9999                # Port of Source database

export APXSID=${ORACLE_SID}       # ORACLE_SID of Source database

export APXSYS=syspwd              # SYSTEM password of Source database

export APXAPP=999                 # Application ID of the application to be exported (not required for export of All)

export APXDIR=/u01/img/apex/18.1  # Installation Directory of Current version of APEX

 To see current settings use:

env | grep APX

To export a specific application

cd ${APXDIR}

java oracle.apex.APEXExport -db ${APXHST}:${APXPRT}:${APXSID} -user system -password ${APXSYS} \

                            -applicationid ${APXAPP} -expPubReports -expSavedReports

To export all applications 

cd ${APXDIR}

java oracle.apex.APEXExport -db ${APXHST}:${APXPRT}:${APXSID} -user system -password ${APXSYS} -instance 

To export all Workspaces 

cd ${APXDIR}

java oracle.apex.APEXExport -db ${APXHST}:${APXPRT}:${APXSID} -user system -password ${APXSYS} -expWorkspace 

To see all arguments

cd ${APXDIR}

java oracle.apex.APEXExport

Application Builder Export

Import

There is no APEXImport Utility. 

You can import through the APEX front-end as a Workspace Administrator but only if you are running an APEX development environment for your production system (which is NOT considered best practice).

You can also connect to the target schema and run the sql file (created by the export) via SQL*Plus, SQLDeveloper or similar.

Bibliography & References