1. Using Oracle Database Cloud Schema Service
  2. Develop Applications for Oracle Database Cloud Schema Service
  3. Export Your Database Schema

Export Your Database Schema

Your Oracle Database Cloud Schema Service provides you with different options to export your database schema quickly and easily to either a secure FTP or a cloud storage.

Topics:

Export to Secure FTP

The Manage options from the Oracle Database Cloud Schema Service service console allow you to easily export and download your database schema using secure file transfer protocol.

To export to secure FTP:
  1. Go to the Service Console for your Schema Service instance. See Access the Service Console.
    The Service Console page displays.
  2. Click the Manage tile.
    The service console manage options display.
    Description of manage_options.png follows
    Description of the illustration manage_options.png
  3. Click Export to Secure FTP.
    The Export to Secure FTP page displays.

    Note:

    The Schema Service accepts a maximum of 10 data export requests. If you want to create a data export request and you have already reached the maximum, you must delete an old request or wait 2 days for the data export to expire and be purged.
  4. To initiate a new export, click Create Export.
  5. To include data with the data structures, select Include Data.
  6. Click Export.

    An Export request is initiated. Wait until the export status has changed to Available before initiating a download of the data export file.

    Note:

    Legacy customers who purchased the Schema Service before August 2017 will see the Export option from the Service Details page. See Create an Oracle Data Pump Export.
After the status changes to Available, the export files are available for two days and downloadable from your secure FTP download area in the download directory.

Create an Oracle Data Pump Export

Use the Service Details page to create a data export file and then go to Export Data to initiate a download of the data export file.

Attention:

This section is applicable only for the legacy customers who purchased the Schema Service before August 2017.

To create an Oracle Data Pump export of your data, code and data structure:

  1. Go to the Service Details page for the Schema Service you want to export. See Access Service Details.

    The Service Detail page displays.

  2. Click Export Data tab.

    The Export Data page displays.

  3. Click the Export Data button.

    The Data Export dialog for your service displays.

  4. To include data with the data structures, select Include Data.
    Description of data_exp_data.gif follows
    Description of the illustration data_exp_data.gif

    Note:

    The Schema Service accepts a maximum of 10 data export requests. If you want to create a data export request and you have already reached the maximum, you must delete an old request or wait 7 days for the data export to expire and be purged.

  5. Click Create Data Export.

    The Data Export page displays and lists the requested data export job.

    Description of export_data_list.gif follows
    Description of the illustration export_data_list.gif
  6. Wait until the export status has changed to Available before initiating a download of the data export file. See Download a Data Export for further instructions.

    Tip:

    Click Refresh to update the data export status.

Download a Data Export

After creating a data export file, and the status of the data export file has changed to available, you can download the file.

See Create an Oracle Data Pump Export.

Attention:

This section is applicable only for the legacy customers who purchased the Schema Service before August 2017.

To download a data export:

  1. Go to the Service Details for the Schema Service that has the data export file you want to download. See Access Service Details.

    The Service Detail page displays.

  2. Under Exports, click Export Data link and make a note of the SFTP host, port and user name.

    Note:

    Your SFTP account password must have been reset at least once since the service was activated. See Set Up Secure FTP Account

    Note:

    The Domain SFTP user will not see the data export files.

  3. Make sure you have some SFTP client software installed and setup to use for the download.
  4. For your SFTP client software, create a new connection or SFTP site. You need the host name, username and password. When using FileZilla, enter information then click Connect.

    The following screenshot shows using FileZilla Site Manager to do this.

    Description of site_mgr.gif follows
    Description of the illustration site_mgr.gif
  5. Once connected, you see two folders:

    • upload - this folder is where the SQL Developer Cloud Deployments arrive

    • download - this folder is where the Data Exports are delivered

    Description of folders.gif follows
    Description of the illustration folders.gif
  6. Double click the download folder.
  7. Select the file in the folder to download.

Export to Cloud Storage

The Manage options from the Oracle Database Cloud Schema Service service console allow you to easily export and download your database schema to an Oracle cloud storage container.

For more information about Oracle Storage Cloud Service, see Oracle Storage Cloud Service in Oracle Help Center.

Note:

All the legacy customers who subscribed to Schema Service prior to August 2017 will not have this option. However, they can still continue exporting their schema using Secure FTP.
To export to an Oracle cloud storage container:
  1. Go to the Service Console for your Schema Service instance. See Access the Service Console.
    The Service Console page displays.
  2. Click the Manage tile.
    The service console manage options display.
    Description of manage_options.png follows
    Description of the illustration manage_options.png
  3. Click Export to Cloud Storage.
    The Export to Cloud Storage page displays. If you have already initiated any exports earlier, a list of all the previous exports initiated earlier is displayed on this page.
  4. To initiate a new export, click Create Export.
    The Create Export dialog appears.
    Description of createexportoscs.png follows
    Description of the illustration createexportoscs.png
  5. Provide the following details, and click Create Export.

    • Cloud Storage Container

      • Enter your Cloud storage container url.

        Enter your Cloud storage container url.

        Tip:

        You can find this url on the Infrastructure Console of your Oracle Storage Cloud Service account. For example, https://foo.storage.oraclecloud.com/v1/Storage-myIdentity/ContainerName, where foo refers to the Oracle Cloud Identity Domain of the storage service instance.

      • Create new container if it does not already exist

        The schema exports are placed in a folder called ContainerName that is provided at the end of the example URL.  Ensure that the Create new container if it does not already exist check-box is selected, if you want to create the container in case it doesn't already exist.

      • Cloud Storage User Name

        Enter the user name that you use to sign in to your cloud storage service account.

        Tip:

        Format to be used is Storage-myIdentity:user@example.com

      • Export File Name

        Select this check-box to include the data also in your export file.

    Your export gets initiated and it takes few minutes to complete the process. Wait until the export status has changed to Available before downloading it from the Oracle cloud storage.

    Note:

    You can cancel an export by clicking the Cancel Export button next to the recent schema export in the list of exports.