Multitenant Import Fails With ORA-39166 (Doc ID 1364740.1)

Last updated on SEPTEMBER 07, 2016

Applies to:

Oracle Argus Safety - Version 7.0.0 and later
Information in this document applies to any platform.
***Checked for currency on 11-Sep-2013***
*** Checked for relevance: 02-Apr-2015 ***

Symptoms

When attempting to merge data from a single source tenant into a multi-tenant target database, the following failure occurs in the log file where SCHEMA_OWNER is the schema owner entered for "Enter Interchange schema owner name in Target Safety Database" section of the import script:

ORA-39166: Object <SCHEMA_OWNER.OBJECT_NAME> was not found.

Cause

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 hundreds of Community platforms