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:

• Lakehouse: If you use SQLLoader to load data, note that Autonomous AI Database does not gather optimizer statistics for your load and you need to gather optimizer statistics manually as explained inManage Optimizer Statistics on Autonomous AI Database. Autonomous AI 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 SQLLoader direct path, do not collect statistics).

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

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