BAM 12c : ORA-00942 Error when populating data into a Data Object migrated from 11g

(Doc ID 1941490.1)

Last updated on NOVEMBER 04, 2014

Applies to:

Oracle BAM (Business Activity Monitoring) - Version and later
Information in this document applies to any platform.


You are attempting to import the definition and data into 12c from an 11g data object.

First you imported the Data Object layout without a problem:

./bamcommand -cmd import -file /tmp/Test.xml -type dataobject -upgrade 1 -name Test -continueonerror 1


But when you try to import the data, the BAM command generates an error:

./bamcommand -cmd import -migrate 1 -type dataobject -file /tmp/Test.xml -continueonerror 1 -mode update

Oracle BAM Import/Export Utility [Build 1, BAM Repository Version 2020] Copyright © 2014, Oracle and/or its affiliates. All rights reserved.
Attempting import of Data Objects from file "/tmp/Maestros.TopClientes.xml".
Error occurred for "DataObject" "Test" :ORA-00942: table or view does not exist



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