This tutorial covers how to load data into an Oracle Database Cloud Service using SQL Developer, as well as export data from your Database Cloud Service.
Time to Complete
Approximately 20 minutes
The Oracle Database Cloud is an ideal platform for building data-centric applications universally available in the Cloud. These applications allow users to add, change, and manipulate data to extract valuable information to allow for better operations and strategic decisions.
Some applications will begin with a clean slate – with data structures defined, but without any data populating those structures. The data is added through user interaction.
A more common scenario is an application where some amount of data already exists, although not in an Oracle Database Cloud Service. This scenario will require data to be loaded into the Oracle Database Cloud Service.
You can load data into your Oracle Database Cloud Service with two different tools – Application Express or SQL Developer.
- In Application Express, SQL Workshop contains an area which allows you to run SQL scripts. These scripts can include both SQL statements and embedded data, and can be used to load data into the Oracle Database Cloud Service. In addition, Application Express has a set of utilities that allow you to load data from a variety of formats, including .csv files, Excel spreadsheets, and text files.
- SQL Developer is a Java-based tool that runs on a client machine. SQL Developer accesses an Oracle Database Cloud Service through a set of RESTful Web Service calls and allows you to access and load data and data structures into your Oracle Database Cloud Service.
In this tutorial, you learn how to load data into an Oracle Database Cloud Service using SQL Developer, as well as export data from your Database Cloud Service from My Services.
Before starting this tutorial, you should have performed the Signing Up for a Database Cloud Service tutorial.
To load data into your Oracle Database Cloud Service, you will need access to an Oracle database and Oracle SQL Developer release 3.2.10.09 or later.
Setting Up Your Database Cloud Service to Allow for Data Uploads from SQL Developer
There are three tasks you need to perform before you can perform the data upload from SQL Developer.
Change the Password for the SFTP User
You need to change the password for the SFTP user defined for your Database Cloud Service. Perform the following steps:
Create a Cloud Connection User in Your Database Cloud Service
You need to create a user to load the tables and data into your Database Cloud Service. Perform the following steps:
Create a Cloud Connection in SQL Developer
You need to create a connection to your Database Cloud Service from SQL Developer. Perform the following steps:
Loading Data into your Database Cloud Service from SQL Developer
In this section, you add some tables from another database into your Cart and deploy to the cloud. Perform the following steps:
Exporting Data from Your Database Cloud Service
In this section, you export your data from your Database Cloud Service. Perform the following steps:
In this tutorial, you have learned how to:
- Set up your Database Cloud Service to allow for data uploads from SQL Developer
- Load data into your Database Cloud Service from SQL Developer
- Export data from your Database Cloud Service
To help navigate this Oracle by Example, note the following:
- Hiding Header Buttons:
- Click the Title to hide the buttons in the header. To show the buttons again, simply click the Title again.
- Topic List Button:
- A list of all the topics. Click one of the topics to navigate to that section.
- Expand/Collapse All Topics:
- To show/hide all the detail for all the sections. By default, all topics are collapsed
- Show/Hide All Images:
- To show/hide all the screenshots. By default, all images are displayed.
- To print the content. The content currently displayed or hidden will be printed.
To navigate to a particular section in this tutorial, select the topic from the list.