Oracle Cloud Infrastructure Documentation

Load Data into Autonomous Database

Describes packages and tools to load data with Autonomous Database.

  • About Data Loading
    Autonomous Database provides many different options to load data into your database.
  • Load Data with Oracle Database Actions
    Oracle Database Actions provides a web-based interface with development tools, data tool, administration, and monitoring features and lets you load or access data from local files, from cloud storage, or from remote databases.
  • Load Data from Files in the Cloud
    The PL/SQL package DBMS_CLOUD provides support for loading data from text, ORC, Parquet, and Avro files in the Cloud to your tables in Autonomous Database. In addition, using DBMS_CLOUD you can load Data Pump dump files in the Cloud to your tables in Autonomous Database.
  • Import Data Using Oracle Data Pump on Autonomous Database
    Oracle Data Pump offers very fast bulk data and metadata movement between Oracle databases and Autonomous Databases.
  • Load Data from Local Files with Oracle Database Actions
    Using Oracle Database Actions, from the Worksheet page, you can load data from local files into an existing table.
  • Load Data or Query Data from Files in a Directory
    You can use DBMS_CLOUD procedures to load data from files in a directory, including directories created on attached network file systems. You can also use these procedures to create external tables that you can use to query data.
  • 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.
  • Using Data Pipelines for Continuous Load and Export
    Data pipelines allow you to repeatedly load data from object store or export data to object store. Load pipelines provide continuous incremental data loading from external sources (as data arrives on object store it is loaded to a database table). Export pipelines provide continuous incremental data exporting to object store (as new data appears in a database table it is exported to object store).
  • The Data Load Page
    Use the Data Load page to make more data available to your Oracle Autonomous Database. You can load data from files or databases, from links to external databases or cloud storage files, or from a live feed of data from cloud storage.
  • Transform Data Using Data Studio
    Data Transforms is an easy-to-use graphical user interface that you can use to design graphical data transformations for data integration with Autonomous Database.
  • View Data Pump Jobs and Import Data with Data Pump
    Use the Data Pump page to view Data Pump jobs and use the wizard to quickly create and run Data Pump import jobs.

Parent topic: Tasks