My Oracle Support Banner

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 FEBRUARY 04, 2019

Applies to:

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


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.


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

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

In this Document

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