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
– As an example, we have created the2 load plans below :
FACT_TABLES_LP
MASTER_TABLES_LP
Get the underlying Work repository relevant schema , you can find its details in the repository connection information :
in sql developer ,connect to OGG_ODI_REPO schema :
– Same load plans existing in ODI and snp_load_plan table :
