Export Database Schemas to Oracle Cloud Infrastructure Object Storage Classic

You can export database cloud schemas to Oracle Cloud Infrastructure Object Storage Classic, download the .dmp file and import the file to an on-premises Oracle Database, or to another cloud database, or to Exadata Express.

You can export database cloud schemas to Oracle Cloud Infrastructure Object Storage Classic container from the Manage page of the Exadata Express service console. To know more about Oracle Cloud Infrastructure Object Storage Classic, see Oracle Cloud Infrastructure Object Storage Classic help center page.

To export a database schema:

  1. Go to the Manage page of the Exadata Express service console and click Export to Cloud Storage. See About Manage.
    The Export to Cloud Storage window displays with a list of recent schema exports. For a new user, the list is empty.
  2. Click Create Export.
    The Export to Cloud Storage window displays.
    Description of create_export_schema.jpg follows
    Description of the illustration create_export_schema.jpg
  3. Provide the URL to the Cloud Storage Container. The URL is displayed on the My Services page of your Oracle Cloud Infrastructure Object Storage Classic account. For example, https://foo.storage.oraclecloud.com/v1/Storage-myIdentity/ContainerName.
    foo refers to the Oracle Cloud Identity Domain of the storage service instance. The Create new container if it does not already exist check-box is selected by default. Deselect the check-box if you want to export schemas to an existing folder.
    The schema exports are placed in a folder called ContainerName that is provided at the end of the example URL.
    Description of create_schema_export.jpg follows
    Description of the illustration create_schema_export.jpg
  4. Provide the Cloud Storage User Name. The following is the format:
    Storage-myIdentity:user@example.com
  5. Enter the Cloud Storage Password.
  6. A default file name is displayed for Export File Name field.
    You can change the default name.
  7. Select the schemas that you want to export from the Schemas to Export list.
  8. Optionally select Include Data and click Create Export.

    Note:

    Schema exports can be overwritten if the export file name is same as an earlier existing name.

    The newly exported schema appears in the list of exports on the Export to Cloud Storage window.
    Description of cancel_export_schema.jpg follows
    Description of the illustration cancel_export_schema.jpg

    The process takes few minutes to export and during this period, you can cancel an export by clicking Cancel Export next to recent schema export appearing in the list of exports.

  9. Download the export file from web console of Oracle Cloud Infrastructure Object Storage Classic by clicking on the Actions drop-down and selecting Download .

    See Also:

    Downloading an Object in Using Oracle Cloud Infrastructure Object Storage Classic