SQL Developer and SQL*Loader 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.

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

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

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

  2. In SQL Developer, click the Export Cart icon and select "loader" in the Format menu.

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

  4. Use a secure copy utility to transfer the SQL*Loader control files and the SQL*Loader data files to the Database service compute node.

  5. On the Database service compute node, invoke SQL*Loader to load the data using the SQL*Loader control files and data files for each object.