10 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.

From the Data Load page, you can also explore the data in your autonomous database and manage your cloud storage locations.

To reach the Data Load page, click Data Load in the Database Actions page, or click the SelectorSelectoricon and select Data Load from the Data Tools menu in the navigation pane.

To load or create links to data or create live table feeds, on the Data Load page, select a combination of an operation and a data source location. The following table lists the operations and the source locations that support those operations.

Operation Source Location Description

Load data

Local file

Database

Cloud storage

Load data from files on your local device, from remote databases, or from cloud storage into tables in your Oracle Autonomous Database.

Link data

Database

Cloud storage

Create external tables or views in your Oracle Autonomous Database that link to data in cloud storage or remote databases. Changes to the source data automatically appear in the target objects.

Feed data

Cloud storage

Set up a feed of data from a cloud storage bucket into a table. Changes to the source data load into the target table as scheduled or on demand.

The following topics describe these actions.

10.1 Checking Data Load Jobs

You can check an existing data load job and retrieve the data load job later when required.

The Data Load Job page displays the data load history in your Oracle Autonomous Database. On the Data Load Page, in the Explore and Connect section, select Data Load Jobs.

The Data Load Job page contains the Search for Data Load Jobs field, a list of Data load job cards. You can enter the data load job you are looking for in the field or click one of the data load jobs from the list.



The Data Load Jobs page consists of:

  1. Search for Data Load Jobs field

    You can click the field and type or search for the name of the data load job you are looking for.

  2. Toolbar

    The toolbar consists of the following buttons:

    • Sort By

      To select sorting values, click the Sort By button to open the list of options. Then click the Ascending or Descending icon next to one or more of the sorting values. For example, if you select the Ascending icon next to Entity name and the Descending icon next to Entity type, the entities will be sorted in alphabetical order by entity name and then in reverse alphabetical order by entity type.

      Click Reset in the list to clear the choices in the list.

      The sorting values you choose are listed next to the Sort by label beneath the toolbar. Click the X icon on a sorting value to remove it.

    • Page size

      By default, up to 25 entities are displayed on the page. If you want more entities on a page, select a number from this list.

    • Previous and Next

      If the search results are displayed on multiple pages, click these buttons to navigate through the pages.

    • Refresh

      Click to refresh the data load jobs shown on the page, based on the current search field.

  3. Filters panel

    Select one or more filter values to limit the data load jobs shown on the page. Only those entities that match the filter values are shown. The filter criteria are based on the schemas and how data is loaded or linked. That is, the items returned by a search are filtered by these filter settings. Selecting all or none of the options shows all entities.

  4. Display Area

    The area beneath the Search for Data Load Jobs field displays the data load job carts returned by a search and that match the filter criteria set in the Filters panel. It displays list of carts which represents a list of previously run data load jobs

You can view details about the job, re-run the Data Load job, Rename the Data Load Job and Delete the Data Load Job.

View Details about the Data Load Job

To view details about the existing data load job, click Action and select View Details in the card for the load job. Selecting View Details displays details like Lineage, Impact and Log details of the data load job.

For details on Lineage, Impact and Log details, see Viewing Entity Details.

Rerun Data Load Job

After viewing details about the selected data load or data link job whose sources are from cloud storage, you can re-run the selected previously run data load job. The previous files and folders processed in that job will be loaded in the cart with all your settings unchanged from the last run. On the left side of the page is a navigator pane, where you choose the cloud store connection and the folders or files containing the data that were previously run. The previously used cloud storage details are already present in the navigator pane. Select additional files or folders from the navigator pane and drop them in the Data Load Cart area. To change the cloud storage connection and the folders and files containing the data, see Managing Cloud Storage Connections

Once you have added the data sources to the data load cart, click the Start icon in the data load cart menu bar. When the data load job completes, the Load Cloud Object page displays the results of the job. At the top of the page, a status message shows the number of items for which the load has completed over the number of items in the job and the total time elapsed for the job. If any previously loaded or linked files and folders are no longer present in the cloud location, an error message reports the problem. You can view the list of unavailable files and folders, which will not be loading into the cart for processing.

Click the Cancel icon to cancel re-running the selected job.

Note:

The Rerun Data Load Job option is visible for data jobs with Load and Link data options for Object storage.

Rename Data Load Job

To rename existing name of data load job cart, select the Rename Data Load Job option. The data load job names are system generated. This option enables you to rename the job to be more descriptive. This makes it easier to search the next time you want to re-run the data load job.

Delete Data Load Job

Select the Delete Data Load Job option to remove the previously run job from the Data load Job page. This will also remove the log files and the error logs generated when attempting to run the data load job.