My Oracle Support Banner

"ORA-00942: table or view does not exist" Error when Opening a Saved List in ODI (Doc ID 2574429.1)

Last updated on FEBRUARY 12, 2024

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Oracle Data Integrator on Marketplace - Version 2.1.0 and later
Information in this document applies to any platform.

Symptoms

When the database user of the Oracle Data Integrator (ODI) work repository is different from the database user of the master repository, loading a list of objects in the "Export Multiple Objects" window results in an ODI-26184 error.

To reproduce:

  1. Create ODI Master Repository (Sample schema owner: ODI_Master) with ODI Studio.
  2. Create ODI Work Repository (Sample schema owner: ODI_Work) with ODI Studio.
  3. Create a scenario.
  4. Select "Export" and underneath, "Export Multiple Objects"
  5. Drag and Drop the scenario to the "Drag and drop objects into the list to export them" panel.
  6. Press "Save export list" icon. and save it.
  7. Close "Export Multiple Objects" window
  8. Reopen "Export Multiple Objects" window
  9. Press "Load a list of objects..." icon. and then, open the saved list from step 6.
  10. The ODI-26184 and ORA-00942 errors occur.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.