About Data Loading

Autonomous Database provides many different options to load data into your database.

You can load data using any of the following methods:

  • You can load data using Oracle Database Actions.

  • You can load data using Oracle Database tools and Oracle or other 3rd party data integration tools.

  • On transaction processing systems you traditionally ingest data through routine transactions or with DML operations.

  • You can load data using DBMS_CLOUD procedures.

In general you load data from files local to your client computer or from files stored in a cloud-based object store, or in connected file systems. To load data from files in the cloud, use either Oracle Database Actions or use the Autonomous Database PL/SQL package DBMS_CLOUD to load files from the cloud, in connected file systems, or the local file system. DBMS_CLOUD provides parallel execution procedures for bulk file upload, download, copy, and transfer activities, which streamlines the user experience and delivers optimal performance for bulk file operations.

For the fastest data loading experience Oracle recommends uploading the source files to a cloud-based object store, such as Oracle Cloud Infrastructure Object Storage, before loading the data into your database. Oracle provides support for loading files that are located locally in your data center, but when using this method of data loading you should factor in the transmission speeds across the Internet which may be significantly slower.

For more information on Oracle Cloud Infrastructure Object Storage, see Putting Data into Object Storage and Overview of Object Storage.

Note

If you are not using ADMIN user, ensure the user has the necessary privileges for the operations the user needs to perform. See Manage User Privileges on Autonomous Database - Connecting with a Client Tool for more information.