Exporting Data

You can create an Oracle Data Pump export of your data and data structure. Export files are downloadable from your secure FTP download area in the outgoing directory. Files are retained for 48 hours. To initiate a download, click the file names using your SFTP client.

Topics:

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

Video iconVideo

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 Service (Schema) credentials and click Sign In.

    The My Services page appears.

  4. Click the name of Oracle Database Cloud Service (Schema).

    The Service Detail page displays.

  5. Under Exports on the left, click Export Data.

    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 Oracle Database Cloud Service (Schema) 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 Downloading a Data Export for further instructions.

    Tip:

    Click Refresh to update the data export status.

Downloading 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 Creating an Oracle Data Pump Export.

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 Service (Schema) credentials and click Sign In.

    The My Services page appears.

  4. Click the name of the Oracle Database Cloud Service (Schema).

    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 Setting 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. The following are examples of SFTP client software:
  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.