Restore APEX Apps and Workspace Files

You will use APEX Application Archive productivity app to import APEX applications and static workspace files into your Autonomous Database.

Import Oracle APEX Apps

To import Oracle APEX apps into your Autonomous Database:

1. Run the APEX Application Archive productivity app, sign in using the database user that you imported, and complete the first time setup if prompted.
2. Click Archived Content and then click Restore for the application you want to restore.

   
   Description of the illustration archived_content_eecs.png

   The archive is exported to the Export Repository within the APEX App Builder.

   
   Description of the illustration content_restored_eecs.png

3. Go back to App Builder. Click Workspace Utilities and then click Export.
4. In the Tasks section, click Export Repository.
5. Now you should see the application SQL file that you restored. Click Install and then select the Reuse Application ID From Export File option. Click Install Application.

   
   Description of the illustration installed_app_eecs.png

6. Repeat this process for all APEX apps you want to import into your Autonomous Database.

Import Static Workspace Files

To import Oracle Application Express (APEX) static workspace files into your Autonomous Database:

1. In the APEX Application Archive productivity app, click Archived Content.
2. Search for "FILES" content type to find the latest archive that contains workspace files. Click Download.
3. In APEX SQL Workshop, click SQL Scripts. Click Upload and then upload the archive file.
4. Once the file is uploaded, click the Run icon associated with this file. Click Run Now.
5. In APEX App Builder, open the app that uses workspace files.
6. Click Shared Components, then click Static Workspace Files in the Files section. Confirm that the expected workspace files are listed.

See Complete the Post-Migration Tasks for additional tasks that may be required before you can run your APEX apps in Autonomous Database.