How To Recreate CSR.CSR_RULES_B And Associated Tables For Migration?
Last updated on FEBRUARY 09, 2018
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***
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:
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
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