1. Migrating Oracle Database Cloud Schema Service Applications to Oracle Cloud Infrastructure
  2. Prepare to Migrate
  3. Create the Data Pump Export in Schema Service

Create the Data Pump Export in Schema Service

In your Oracle Database Cloud Schema Service create a Data Pump Export file of the Oracle Application Express (APEX) app you want to migrate.

Follow the steps in Export Your Database Schema in the Using Oracle Database Cloud Schema Service to export data structures and data to Secure FTP or Object Storage Classic. APEX app definitions and RESTful services are automatically included in this export.

Once the export file is available (for example, aaab.zip), download it and extract export.dmp and param.helper files. Examine the param.helper text file to identify the APEX tablespace name that was used in your Schema Service database. You will provide this tablespace name to impdp utility later.

Note:

If you have APEX Application Archive productivity app installed in your Schema Service workspace, uninstall it prior to submitting the data export request. In APEX App Gallery, find the APEX Application Archive app, click Manage, then click Remove. If you need to retain past archives, submit a separate data export request and wait for it to become available before uninstalling the app.

For additional information, see: