How To Recreate CSR.CSR_RULES_B And Associated Tables For Migration? (Doc ID 1551628.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Scheduler - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 06-Nov-2014***

Goal

Doing a migraton from HPUX to Linux using trasportable tablespaces.

During the process, encountered these type for errors.
Please fix the following errors before continuing:

ORA-39928: TABLE CSR.CSR_RULES_B in tablespace APPS_TS_TX_DATA contains evolved
type data that have not been upgraded.
ORA-39928: TABLE APPS.spPlanScope283_TAB in tablespace APPS_TS_TX_DATA contains
evolved type data that have not been upgraded.
ORA-39928: TABLE APPS.spMaxPlanOptions284_TAB in tablespace APPS_TS_TX_DATA
contains evolved type data that have not been upgraded.
ORA-39928: TABLE APPS.spMaxCalcTime285_TAB in tablespace APPS_TS_TX_DATA


How to recreate the objects then this issue goes away as it is related to the way the xml type is stored in 11g vs 10g?
Oracle XML DB Developers Guide E23094-02

 

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