Loading Data into the Oracle Database on Database Cloud Service

You load data into an Oracle database on Oracle Database Cloud Service using the same tools you would use for an Oracle database on another system.

If you are using Database Cloud Service on Oracle Cloud, the location of the database in an Oracle data center does not place any special restrictions on data loading. However, transmission speeds across the Internet tend to be slower, sometimes much slower, than on internal networks, and you should factor this in when choosing any data loading approach.

The location of the database in an Oracle data center does not place any special restrictions on data loading. However, transmission speeds across the Internet tend to be slower, sometimes much slower, than on internal networks, and you should factor this in when choosing any data loading approach.

The following sections outline several common tools and techniques used to load data into an Oracle database. Also, see Migrating Oracle Databases to Database Cloud Service for additional techniques and more specific information about migrating existing Oracle databases to Database Cloud Service.

Using SQL*Loader to Load Data into the Database

SQL*Loader is a high-speed data loading utility that loads data from external files into tables in an Oracle database. SQL*Loader accepts input data in a variety of formats, can perform filtering, and can load data into multiple Oracle database tables during the same load session. SQL*Loader provides three methods for loading data: Conventional Path Load, Direct Path Load, and External Table Load.

For information, see "SQL Loader" in Oracle Database Utilities for Release 18, 12.2, 12.1 or 11.2.

Using Oracle Data Pump Import to Load Data into the Database

Oracle Data Pump is an Oracle Database feature that offers very fast bulk data and metadata movement between Oracle databases. Oracle Data Pump provides two high-speed, parallel utilities: Export (expdp) and Import (impdp). Data Pump automatically manages multiple, parallel streams for maximum throughput of unload and load operations. The degree of parallelism can be adjusted on-the-fly.

For information, see "Data Pump Import" in Oracle Database Utilities for Release 18, 12.2, 12.1 or 11.2.

Using Transportable Tablespaces to Load Data into the Database

Transportable Tablespaces is an Oracle Database feature that copies a set of tablespaces from one Oracle database to another. Moving data using transportable tablespaces can be much more efficient than performing either an export/import or unload/load of the same data. This is because the tablespace datafiles are copied to the destination location, which avoids the cost of formatting the data into Oracle blocks. Also, in some circumstances, your Transportable Tablespace can contain previously encrypted or compressed data, which avoids the cost of decrypting and re-encrypting, or expanding and re-compressing the data.

For information, see "Transporting Tablespaces Between Databases" in Oracle Database Administrator's Guide for Release 18, 12.2, 12.1 or 11.2.

Using Pluggable Databases (PDBs) to Load Data into the Database

The multitenant architecture of Oracle Database 12c and later releases supports the moving of a pluggable database (PDB) from one container database (CDB) to another. This capability makes it easy to load data into Database Cloud Service, provided that the source data is already inside a PDB on Oracle Database 12c or a later release.

For information about PDBs and how to unplug, move, and plug them, see "Overview of Configuring and Managing a Multitenant Environment" in Oracle Multitenant Administrator’s Guide for Release 18 or "Overview of Managing a Multitenant Environment" in Oracle Database Administrator's Guide for Release 12.2 or 12.1.