MDL1261 And MDL1407 Cannot Import PARTITION For a Partitioned Table During Entire Repository Import in OWB 11.2 (Doc ID 1335347.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2 to 11.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

The OWB 11.2 Repository Assistant fails to import a 10.2 Entire Repository with the following error:

executeOwbReposOrRuntime]: Error occurred during Importing Entire Repository.
Exception =java.lang.Exception: Exception occured importing entire
repository: org.xml.sax.SAXExcept
ion: MDL1261: Error importing PARTITION PARTITION_01_20041231.

Detailed Error Message:
java.lang.Exception: Error at line 1,737,177: MDL1261: Error importing PARTITION TABLE_NAME.PARTITIONS.PARTITION_01_20041231.

Detailed Error Message:
MDL1407: Cannot import PARTITION with physical name <PARTITION_01_20041231> matching by object identifier because a PARTITION <TABME_NAME.PARTITION_01_20041231> with the same physical name <PARTITION_01_20041231> but different object identifier already exists.

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