How to Use SQL Developer to Upload Data to an Oracle Database Cloud Schema Service (Doc ID 1966335.1)

Last updated on JULY 27, 2017

Applies to:

Oracle Database Cloud Service - S50 - Version N/A and later
Oracle SQL Developer - Version 3.2 and later
Oracle Database Cloud Service - S5 - Version N/A and later
Oracle Database Cloud Service - S20 - Version N/A and later
Information in this document applies to any platform.

Goal

To demonstrate how to use the SQL Developer Cart feature to upload data to the Oracle Database Cloud.
For the Database Cloud Schema Service, SQL Developer may be used for upload, but download is not allowed.  

SQL Developer 3.2.10 or higher must be used.

 

See the following document for other data loading options in the Schema Service:

http://www.ateam-oracle.com/loading-data-in-oracle-database-cloud-service/

This document discusses the following data loading methods, as well as appropriate usage:

  • Using DbCS Console (APEX console) to export/import data
  • Using Database Cart feature within SQL Developer (and Oracle JDeveloper)
  • Using DbCS inbound REST Services
  • Using DBCS to invoke SOAP and REST Services programmatically

With 4.1, the SQL Developer Command Line interface can also be used to load data. See:
http://www.thatjeffsmith.com/archive/2015/03/batch-loading-your-oracle-database-cloud-services-via-the-sql-developer-command-line-interface/

This feature is beta at this writing and is supported on the SQL Developer forum.

 
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms