Export Your Database Schema

Your Oracle Database Cloud - Database 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 - Database 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 Database Schema Service instance. See Access the Service Console.
    The Service Console page displays.
  2. Click the Manage tile.
    The service console manage options display.
  3. Click Export to Secure FTP.
    The Export to Secure FTP page displays.

    Note:

    The Database 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 Database 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 My Services to create a data export file. 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 Database Schema Service before August 2017.

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

  1. From the Oracle Cloud home page, click Sign In.

    The Sign In page appears.

  2. Under My Services, select the data center and click Sign In to My Services.
  3. If not already signed in, the Sign in dialog displays. Enter Oracle Database Cloud - Database Schema Service credentials and click Sign In.

    The My Services page appears.

  4. Click the name of Database Schema Service.

    The Service Detail page displays.

  5. Click Export Data tab.

    The Export Data page displays.

  6. Click the Export Data button.

    The Data Export dialog for your service displays.

  7. To include data with the data structures, select Include Data.

    Note:

    The Database 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.

  8. Click Create Data Export.

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

  9. 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 Database Schema Service before August 2017.

To download a data export:

  1. From the Oracle Cloud home page, click Sign In.

    The Sign In page appears.

  2. In the My Services box, select the data center and click Sign In to My Services.
  3. If not already signed in, the Sign in dialog displays. Enter Oracle Database Cloud - Database Schema Service credentials and click Sign In.

    The My Services page appears.

  4. Click the name of the Database Schema Service.

    The Service Detail page displays.

  5. 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.

  6. Make sure you have some SFTP client software installed and setup to use for the download.
  7. 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.

  8. 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

  9. Double click the download folder.
  10. Select the file in the folder to download.

Export to Cloud Storage

The Manage options from the Oracle Database Cloud - Database 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 Database 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 Database Schema Service instance. See Access the Service Console.
    The Service Console page displays.
  2. Click the Manage tile.
    The service console manage options display.
  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.
  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 My Services page 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.