Oracle Cloud Infrastructure Documentation

SQL Developer and INSERT Statements to Migrate Selected Objects

You can use SQL Developer to create a cart into which you add selected objects to be loaded into an Oracle Database 12c database in the Oracle Cloud Infrastructure Database service.

In this method, you use SQL INSERT statements to load the data into your cloud database.

To migrate selected objects to an Oracle Database 12c database in a Database service deployment using SQL Developer and INSERT statements, you perform these tasks:

  1. Launch SQL Developer, connect to your on-premises database and create a cart containing the objects you want to migrate.

  2. In SQL Developer, click the Export Cart icon and select “Insert” in the Format menu.

  3. In SQL Developer, open a connection to the Oracle Database 12c database in the Database service and execute the generated script to create the database objects.

  4. In SQL Developer, open a connection to the Oracle Database 12c database in the Database service and run the generated script to create the objects and load the data.