---
title: Oracle - Load data - Native Load Control
description: Load the deployed Oracle solution with the native load control by running execute.ps1.
---

[Skip to content](https://knowledge.bigenius-x.com/oracle-load-data-native-load-control#main-content)

[Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal?hsLang=en)

[![TRI\_Logo\_biGENIUS\_2020\_RGB\_s](https://knowledge.bigenius-x.com/hs-fs/hubfs/Marketing/TRI_Logo_biGENIUS_2020_RGB_s.png?width=150&height=42&name=TRI_Logo_biGENIUS_2020_RGB_s.png)](https://www.bigenius-x.com/)

Open main navigation

Close main navigation

- [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new)
- [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [biGENIUS-X Knowledge Base](https://knowledge.bigenius-x.com/?hsLang=en)
2. [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en)
3. [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control)

# Oracle - Load data - Native Load Control

**Applies to**  
Platform: Oracle

Load the deployed Oracle solution with the native load control by running `execute.ps1`. The script builds the execution plan of the project, runs every loader in dependency order and reports the loaders that did not succeed. Afterwards the view `V_LASTLOAD` shows the result of each loader.

How the load control plans, runs and logs loads is explained in [Understand Load Control](https://knowledge.bigenius-x.com/understand-load-control?hsLang=en).

### Prerequisites

- [LoadControl Options](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en) contains `Native Load Control`.
- The artifacts are [deployed](https://knowledge.bigenius-x.com/oracle-deployment?hsLang=en) without errors, including the load control.
- The load-control user has `EXECUTE` on `SYS.DBMS_LOCK`, see [Oracle - Target environment](https://knowledge.bigenius-x.com/oracle-target-environment?hsLang=en).
- PowerShell 7 and SQL\*Plus are installed.

### Load the data

1. Open PowerShell 7 in the artifacts folder, the folder that contains `execute.ps1`.
2. Run `.\execute.ps1`. The script connects as the load-control user and runs `LoadControl\LoadControl_Execution_<project>.sql`. It returns when the execution has ended.
3. Read `NUMBER_OF_FAILED_OR_DISABLED_LOADERS` in the output. `0` means that every loader succeeded.

The execution script builds the execution plan `DEV_<project>`, adds all load objects of the load configuration `<project>` and starts it. `<project>` is the project name, for example `test.datavault.oracle`. All loaders of one execution use the same load timestamp, taken from the database clock when the execution starts.

### Check the result

Connect as the load-control user and query the last execution:

```
SELECT LOAD_OBJECT, EXECUTION_RESULT, NUMBER_OF_ROWS_INSERTED,
       ERROR_DESCRIPTION
FROM V_LASTLOAD;
```

Each loader has one row. `EXECUTION_RESULT` is `Success` for a loader that ran without error. More queries are in [Monitor Load Control](https://knowledge.bigenius-x.com/monitor-load-control?hsLang=en).

### Example

The Data Vault project `test.datavault.oracle` has 105 load objects. Its first load on a local database took about 30 seconds and printed:

```
=> Executing LoadControl/LoadControl_Execution_test.datavault.oracle.sql

NUMBER_OF_FAILED_OR_DISABLED_LOADERS
------------------------------------
                                   0

=> LoadControl/LoadControl_Execution_test.datavault.oracle.sql finished
```

`V_LASTLOAD` then held 105 rows, all with `EXECUTION_RESULT` `Success`. All loaded tables had the same `BG_LOADTIMESTAMP`.

### Run other execution plans

`LoadControl_Execution_<project>.sql` contains commented examples for other calls: a plan with the Stage layer only, removing load objects from a plan, removing a plan, and stopping or resuming an execution. On Oracle you call the procedures in a PL/SQL block. The procedures are described in [Plan Load Control](https://knowledge.bigenius-x.com/plan-load-control?hsLang=en) and [Execute Load Control](https://knowledge.bigenius-x.com/execute-load-control?hsLang=en).

### Load several projects with one load control

Several projects, for example a Data Vault and a Data Mart on top of it, can share one load control:

1. Keep [Deploy LoadControl](https://knowledge.bigenius-x.com/deploy-loadcontrol-project?hsLang=en) `true` in the project that deploys the load control, and set it to `false` in the others.
2. Enter the same `loadcontrol#loadcontrol#` values in the replacement configuration of every project.
3. Deploy the load-control project first, then the others. Each project registers its own load configuration.
4. Run `.\execute.ps1` of each project in load order, for example the Data Vault before the Data Mart.

Deploying a project with Deploy LoadControl set to true recreates the load control tables and removes the configuration of the other projects, your execution plans and execution history. Deploy the load control with one project only and set Deploy LoadControl to false in the others.

### Failure symptoms and recovery

#### Some loaders failed or were disabled

Message: `NUMBER_OF_FAILED_OR_DISABLED_LOADERS` greater than 0  
Cause: A loader failed; the loaders that depend on it were not run.  
Fix: Query `V_LASTLOAD` for rows whose `EXECUTION_RESULT` is not `Success` and read `ERROR_DESCRIPTION`. Correct the cause, then resume the execution as described in [Execute Load Control](https://knowledge.bigenius-x.com/execute-load-control?hsLang=en).

#### The view V\_LASTLOAD does not exist

Message: `ORA-00942: table or view "<user name>"."V_LASTLOAD" does not exist`  
Cause: The load-control user is not the load-control schema, or the load control was not deployed.  
Fix: Set `user_name` and `schema_name` of the load control to the same user and deploy again.

#### Load-control procedures are invalid after deployment

Message: `PLS-00201` for `DBMS_LOCK` in the invalid objects of the deployment  
Cause: The load-control user has no `EXECUTE` on `SYS.DBMS_LOCK`.  
Fix: Grant it, deploy again and run `.\execute.ps1`.

### Related articles

- Previous: [Oracle - Deployment](https://knowledge.bigenius-x.com/oracle-deployment?hsLang=en)
- Reference: [LoadControl Options (Project)](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en), [Deploy LoadControl (Project)](https://knowledge.bigenius-x.com/deploy-loadcontrol-project?hsLang=en), [Configure LoadControl (Project)](https://knowledge.bigenius-x.com/configure-loadcontrol-project?hsLang=en)
- See also: [Understand Load Control](https://knowledge.bigenius-x.com/understand-load-control?hsLang=en), [Native - Load control environment](https://knowledge.bigenius-x.com/native-load-control-environment?hsLang=en), [Plan Load Control](https://knowledge.bigenius-x.com/plan-load-control?hsLang=en), [Execute Load Control](https://knowledge.bigenius-x.com/execute-load-control?hsLang=en), [Monitor Load Control](https://knowledge.bigenius-x.com/monitor-load-control?hsLang=en), [Oracle - Load data - Apache Airflow Load Control](https://knowledge.bigenius-x.com/oracle-load-data-apache-airflow-load-control?hsLang=en)

- [Getting started](https://knowledge.bigenius-x.com/getting-started?hsLang=en#main-content)

    - [Guidelines](https://knowledge.bigenius-x.com/getting-started?hsLang=en#guidelines)
    - [Start working](https://knowledge.bigenius-x.com/getting-started?hsLang=en#start-working)
    - [Account](https://knowledge.bigenius-x.com/getting-started?hsLang=en#account)
- [General overview](https://knowledge.bigenius-x.com/general-overview?hsLang=en)
- [Artificial Intelligence](https://knowledge.bigenius-x.com/artificial-intelligence?hsLang=en)
- [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en#main-content)

    - [Administration](https://knowledge.bigenius-x.com/application-modules?hsLang=en#administration)
    - [Solutions](https://knowledge.bigenius-x.com/application-modules?hsLang=en#solutions)
    - [Global Features](https://knowledge.bigenius-x.com/application-modules?hsLang=en#global-features)
    - [Projects](https://knowledge.bigenius-x.com/application-modules?hsLang=en#projects)
    - [Branches](https://knowledge.bigenius-x.com/application-modules?hsLang=en#branches)
    - [Data Connections](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-connections)
    - [Dataflow Modeling - Overview](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-overview)
    - [Dataflow Modeling - Wizard Steps](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-wizard-steps)
    - [Dataflow Modeling - Terms](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-terms)
    - [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping)
    - [Dataflow Modeling - Relationships](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-relationships)
    - [Dataflow Modeling - Data Quality](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-data-quality)
    - [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-indexes)
    - [Relationship Modeling](https://knowledge.bigenius-x.com/application-modules?hsLang=en#relationship-modeling)
    - [Generate Artifacts](https://knowledge.bigenius-x.com/application-modules?hsLang=en#generate-artifacts)
    - [Project Settings](https://knowledge.bigenius-x.com/application-modules?hsLang=en#project-settings)
    - [Data Marketplace](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-marketplace)
- [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en#main-content)

    - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse)
    - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse)
    - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks)
    - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake)
    - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server)
    - [Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#artifacts)
    - [Replace Placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders)
    - [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment)
    - [Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment)
    - [Deployment with an Azuze DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azuze-devops-pipeline)
    - [Delta Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#delta-deployment)
    - [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment)
    - [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control)
    - [Load data with Apache Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow)
    - [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type)
    - [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties)
    - [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms)
- [Discovery application](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#main-content)

    - [Discovery configurations](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#discovery-configurations)
- [Best practices](https://knowledge.bigenius-x.com/best-practices?hsLang=en#main-content)

    - [Modeling Approaches](https://knowledge.bigenius-x.com/best-practices?hsLang=en#modeling-approaches)
    - [Use Cases](https://knowledge.bigenius-x.com/best-practices?hsLang=en#use-cases)
    - [Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules)
    - [Data Quality Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#data-quality-rules)
- [FAQs](https://knowledge.bigenius-x.com/faqs?hsLang=en)
- [Product Release Notes](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#main-content)

    - [SaaS Application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#saas-application)
    - [Discovery application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#discovery-application)
    - [Generators](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#generators)
- [Legal Documents](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#main-content)

    - [Current legal docs](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#current-legal-docs)
    - [Software Product and Limits](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#software-product-and-limits)

- [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en)
- [Customer Portal](https://knowledge.bigenius-x.com/customer-portal)
- [Sign in](https://knowledge.bigenius-x.com/_hcms/mem/login)

[![biGENIUS logo](https://knowledge.bigenius-x.com/hubfs/TRI_Logo_biGENIUS_2020_RGB-1.svg "biGENIUS logo")](https://www.bigenius-x.com)

<https://www.linkedin.com/company/bigenius> <https://www.youtube.com/@biGENIUS_DWA>

All rights reserved © 2025, biGENIUS AG