I am in the process of patching/upgrading a Webcenter PS2 install (11.1.1.3) with UCM 10g to a Webcenter PS3 install (11.1.1.4) using the Weblogic migration tools, Patch Set Assistant to migrate the schemas and the ECM migration tools.
One of the things I was curious about was the RCU schemas and tablespace differences in PS2 vs PS3 … what stays and what goes? how much of it is different?
Webcenter 11.1.1.2/11.1.1.3 Schemas
SQL> select version,status,owner from schema_version_registry; VERSION STATUS OWNER ------------------------------ ----------- ------------------------------ 11.1.1.2.0 VALID DEV_DISCUSSIONS 11.1.1.2.0 VALID DEV_DISCUSSIONS_CRAWLER 11.1.1.2.0 VALID DEV_MDS 11.1.1.2.0 VALID DEV_OCSERVER 11.1.1.2.0 VALID DEV_PORTLET 11.1.1.2.0 VALID DEV_WEBCENTER 11.1.1.2.0 VALID DEV_WIKI SQL> select version,status,owner from schema_version_registry;
Webcenter 11.1.1.4 Schemas
VERSION STATUS OWNER ------------------------------ ----------- ------------------------------ 11.1.1.4.0 VALID DEV_DISCUSSIONS 11.1.1.4.0 VALID DEV_DISCUSSIONS_CRAWLER 11.1.1.2.1 VALID DEV_IPM 11.1.1.2.1 VALID DEV_ORAIRM 11.1.1.4.0 VALID DEV_MDS 11.1.1.4.0 VALID DEV_OCS 11.1.1.4.0 VALID DEV_OCSSEARCH 11.1.1.2.0 VALID DEV_PORTLET 11.1.1.4.0 VALID DEV_URMSERVER 11.1.1.4.0 VALID DEV_WEBCENTER 11.1.1.4.0 VALID DEV_ACTIVITIES