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 into Existing Autonomous Database Table with Oracle Database Actions

You can load data into an existing table in Autonomous Database with the Database Actions import from file feature.

Before you load data, create the table in Autonomous Database. The file formats that you can upload with the Database Actions upload feature are CSV, XLS, XLSX, TSV and TXT.

To upload data from local files to an existing table with Database Actions, do the following:

  1. Access Database Actions from the Oracle Cloud Infrastructure Console or with the Database Actions link provided to you.
  2. To import data, in Database Actions, under Development click SQL.

    This shows an SQL worksheet.

    Description of adb_dbactions_worksheet.png follows
  3. In the Navigator, right-click the table where you want to load data.
  4. In the menu select Data loadingUpload Data...

    For example, select the SALES table, right-click, and select Data loadingUpload Data...


    Description of adb_dbactions_upload.png follows

    This shows the Import data dialog:


    Description of adb_dbactions_import.png follows

  5. In the Import data dialog you can either drag and drop files or click Select files to show a browser to select the files to import.
  6. Complete the mapping for the columns you are importing. There are a number of options for column mapping. Click Show/Hide options (Show/Hide options) icon to show the data import and format options to change column names, skip rows, rows to load, and various other options.

    Click Apply to apply the options you select.

  7. When you finish selecting format and mapping options, click Next to preview the column mapping.

    If there is a problem at this stage, information shows with more details, such as: 2 pending actions. This means you need to correct or fix the source file data before you import.

    Description of adb_dbactions_import_cmapping.png follows
  8. Click Next.
  9. Click Next to review the column mapping.

    This shows the Review page to review the source columns and target columns for the import:

    Description of adb_dbactions_import_review.png follows
  10. Click Finish.
  11. Click OK to confirm the import.

    Depending on the size of the data file you are importing, the import may take some time.

Database Actions provides history to show the status of the import and to allow you to review the results or errors associated with the import operation.

For a detailed summary of the upload process, right-click the table in the Navigator tab, select Data loading, and then select Loaded Data. A summary of the data loaded is displayed in the Loaded data summary dialog.

If any data failed to load, you can view the number of rows in the Failed Rows column. Click the column and a dialog is displayed showing the failed rows.

In the Loaded data summary dialog, you can also search for files loaded by schema name, table name, or file name. To remove the loaded files, click the Delete icon.

See Uploading Data from Local Files for more information on using Database Actions to upload data.