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

APEXExport

To Migrate APEX Workspaces and Applications from one Database Instance to another...

Ensure JAVA Environment is appropriately set

Set Variables

Unless you are exporting from a different instance, all variables except APPLID and SYSPWD 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

Import

There is no APEXImport Utility. You need to import through the APEX front-end as a Workspace Administrator.

Bibliography