What is the function of ODI_LOAD_PLAN Table ?

All of ODI objects, whether master or work repository related, are saved in database tables.

While you can get some info from those tables using a database connection, you can’t add / or delete or alter them prior referring to Oracle support first, so that you can keep your tool running consistently without data dictionary corruption.

When load plans are created, their info is saved in the work repository  ODI_LOAD_PLAN database table .

In the example below, we shall use the Getting Started with Oracle Data Integrator Getting Started, 12c (12.2.1.3.0) Virtual machine.

-Connect to the work repository : OGG_ODI_WREP

ODI LOAD PLAN

– As an example, we  have created the2 load plans below :

FACT_TABLES_LP

MASTER_TABLES_LP

 

ODI load plans

 

Get the underlying Work repository relevant schema , you can find its details in the repository connection information :

repository connection information

repository connection information

 

in sql developer ,connect to OGG_ODI_REPO schema :

OGG_ODI_REPO schema

– Same load plans existing in ODI and snp_load_plan table :

snp load plan table

 

snp load plan table

 

 

Related Articles

Picture of Technical Director

Technical Director

Tamer Shalaby is A highly experienced Oracle Certified Specialist Software Engineer with over two decades of international expertise. His career spans sixteen countries across Europe, the Middle East, and Africa, where he has specialized in data analytics, business intelligence, and database administration. The text details a comprehensive background in API integration, ETL processes, and cloud analytics, including a significant tenure at Oracle Corporation and various director-level roles. His portfolio includes successful project deliveries for major global entities in sectors such as telecommunications, banking, and government. Furthermore, the record highlights his academic credentials in computer software engineering alongside numerous technical certifications and prestigious industry awards.

My Personal Favourites