Oracle Cloud Infrastructure Documentation

Load Data from Local Files Using SQL*Loader

Instead of using SQL*Loader Oracle recommends loading data from the Cloud Object Storage for better performance and enhanced functionality.

For information on loading from Cloud Object Store, see Load Data from Files in the Cloud.

Depending on your workload type, note the following:

  • Data Warehouse: If you use SQL*Loader to load data, note that Autonomous Database does not gather optimizer statistics for your load and you need to gather optimizer statistics manually as explained in Manage Optimizer Statistics on Autonomous Database. Autonomous Database gathers optimizer statistics automatically for tables loaded with direct path operations issued in SQL (direct path load operations that bypass the SQL data processing, such as SQL*Loader direct path, do not collect statistics).

  • Transaction Processing or JSON Database: If you use SQL*Loader to load data, note that Autonomous Database does not gather optimizer statistics for your load and you need to gather optimizer statistics manually as explained in in Manage Optimizer Statistics on Autonomous Database or wait for the automatic statistic gathering task to kick in.

For detailed information on SQL*Loader see, Oracle Database Utilities.