My Oracle Support Banner

How to manually move composite-partitioned table and index? (Doc ID 1270700.1)

Last updated on JUNE 23, 2019

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 07-May-2013***

Goal


How do we handle these exceptions?

Running the OATM migration utility.
After answering the following initial questions:

- Migration Sizing Reports
- Generate a Report with the list of all the Oracle Application product schemas that can be migrated
- Display Sizing Exception report

The exception report contains several objects with the error message :

EGO.EGO_MTL_SY_ITEMS_EXT_B

EGO.EGO_MTL_SY_ITEMS_EXT_B_N1

EGO.EGO_MTL_SY_ITEMS_EXT_TL

EGO.EGO_MTL_SY_ITEMS_EXT_TL_N1
-----------------------------------------------------------------------
ORA-03207: subpartitioned type must be specified for composite object
-----------------------------------------------------------------------


Solution

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
Goal
Solution
References


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