Oracle by Example brandingUsing SQL Developer Cart Utility to Load Data into an Oracle Exadata Express Cloud Service

section 0Before You Begin

This tutorial shows you how to use Oracle SQL Developer Cart utility to load data into your Oracle Database Exadata Express Cloud service.

This is the second tutorial in the series Using SQL Developer to Load Data into your Oracle Database Exadata Express Cloud Service. Read the tutorials in any order.

This tutorial takes approximately 10 minutes to complete.

Background

Oracle SQL Developer creates a cart containing objects you want to load into your Oracle Database Exadata Express Cloud Service. SQL Developer connects to your service and deploys data from the cart to the service. Use the cart when you need to create a subset of objects from one or more schemas locally that you want to deploy to another database on a regular basis.

What Do You Need?

  • Oracle SQL Developer installed in your system
  • Connection to an Oracle Database, which is the data source
  • Oracle Database Exadata Express Cloud Service account
  • Connection to an Oracle Database Exadata Express Cloud Service instance, which is the target

section 1Using SQL Developer Cart Utility to Load Data into an Oracle Exadata Express Cloud Service

Use the SQL Developer Cart option to load data into Oracle Exadata Express Cloud Service. To use the SQL Developer Cart:

  1. Open Oracle SQL Developer and click View in the menu bar. The View menu opens.
    Description of the illustration [view_cart.png]
  2. In the View menu, click Cart. The Cart window opens in the bottom right corner.
  3. Drag and drop the Oracle Database objects from your on-premise database into the Cart window.
    Description of the illustration [sql_dev_cart.png]
  4. If you want to include data with the cart deployment, then click Data in the Cart window.
  5. To deploy the cart, click the Copy icon at the top right of the Cart window. Alternately, you can press Ctrl+C.
    Description of the illustration [copy_icon_in_cart]
    The Copy Objects dialog box opens.
  6. In the Copy Objects dialog box, select your Exadata Express connection in the Destination Connection drop down list. Select the appropriate options under Copy DDL and Copy Data.
    Description of the illustration [copy_objects]
  7. Click Apply. The Copying dialog box opens, indicating the status of copying the cart objects.
    Description of the illustration copying.png
    8. All the database objects added to the cart are copied to your Oracle Exadata Express connection in Oracle SQL Developer. You can browse the Connections tree to verify if the selected database objects are copied in your Exadata Express connection.

next stepNext Tutorial

  • Using SQL Developer Drag and Drop to Load Data into an Oracle Exadata Express Cloud Service

more informationWant to Learn More?