You load data into an Oracle database on Oracle Database Exadata Cloud at Customer using the same tools you would use for an Oracle database on another system.
The following sections outline several common tools and techniques used to load data into an Oracle database. Also, see Migrating Oracle Databases to Exadata Cloud at Customer for additional techniques and more specific information about migrating existing Oracle databases to Exadata Cloud at Customer.
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.
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.
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.
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 Exadata Cloud at Customer, 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.