How to Use SQL Developer to Upload Data to an Oracle Database Cloud Schema Service

(Doc ID 1966335.1)

Last updated on SEPTEMBER 21, 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 SQL Workshop console) to export/import data
--The "Data Workshop" option can be used to load and unload data using text files, XML, or a spreadsheet. (Note that there are data size restrictions)
--The "Generate DDL" option can be used to generate scripts for all or selected DB objects in the schema.
Using Database Cart feature within SQL Developer (and Oracle JDeveloper) - Only for uploading Data to a Schema Service.
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/

Note that if you want to unload large amounts of data from your Schema Service the most practical option is to:

1. Export the entire schema using the Dashboard -> APEX -> Exports (Export Data) > Export Data button
2. This is a DataPump export which can be loaded into an on-premise DB using the standard DataPump utility.

 
 

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