upgrading/migrating our Database by using XTTS (Transporatable Tablespace) We can't use as CXTSYS already migrated to APPS_TS_TX_DATA as a part of OATM
We are in process to upgrade/migrate our database from 188.8.131.52 to 184.108.40.206 and from Linux to AIX while following MOS id "1311487.1" and realized that CTXSYS schema as a part of our OATM migration process in past was migrated to APPS_TS_TX_DATA tablespace. Another MOS id "454574.1" explains that XTTS isn't supported if CTXSYS got migratd to OATM model.
Since this is already done for our environment, so is there a possibility that we can still use XTTS for our database/migrated while CTXSYS resides in OATM model? Is there a workaround or any option to move back CTXSYS schema outside from the OATM model?
Thanks in Advance
What about moving CTXSYS to a spearate tablespace (like SYSAUX) as mentioned in the doc?
OATM MIGRATION OF CTXSYS OBJECTS FAILS [ID 417742.1]
FAQ - OATM - Oracle Applications Tablespace Migration [ID 418225.1]
OATM Errors Out When Moving Intermedia Indexes [ID 365466.1]
How to run OATM migration utility [ID 404954.1]