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

Last updated on AUGUST 01, 2016

Applies to:

Oracle Applications 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

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