1. Migrating Oracle Database Cloud Schema Service Applications to Oracle Cloud Infrastructure
  2. Migrate Your Apps
  3. Create an APEX Workspace in Autonomous Database

Create an APEX Workspace in Autonomous Database

Follow the steps below to create an Oracle Application Express (APEX) workspace in your Oracle Autonomous Database. To ensure transparent workspace migration, the new workspace uses the same workspace ID as your existing Oracle Database Cloud Schema Service workspace.

  1. Sign in to your Oracle APEX workspace in your Schema Service.
  2. Click the ? icon in the upper right. Choose About, and then copy your Workspace ID.
    Description of about_apex.png follows
    Description of the illustration about_apex.png

  3. Sign in to your Autonomous Database service console.
  4. Click Development on the left side, then click APEX.

    Oracle Application Express Administration Services sign-in page appears.

    Note:

    If you already created a workspace, the workspace sign-in page appears instead. In this case, to proceed, click the Administration Services link.
  5. Enter the Autonomous Database administrator (ADMIN) password on the sign-in page and click Sign In to Administration.
    Description of adb_signin.png follows
    Description of the illustration adb_signin.png

  6. In Administration Services, click Create Workspace and select the Database User that you imported. Ensure the Workspace Name matches your Schema Service workspace. Expand the Advanced section and enter the same Workspace ID as you copied in an earlier step. Click Create Workspace.
    Description of create_ws.png follows
    Description of the illustration create_ws.png

  7. Click the link of the workspace name in the success message. The workspace sign-in page appears with Workspace and Username fields populated. Enter the password for the database user and click Sign In.
  8. Click Set APEX Account Password and enter the same password you just used to sign in to Oracle APEX.
  9. Click App Builder, then click Install a Productivity or Sample App.
    Description of app_builder.png follows
    Description of the illustration app_builder.png

  10. Find the APEX Application Archive app in the App Gallery list and click Install App. Click Next, then click Install App.
For additional information, see: