Oracle Webcenter Schemas and Tablespaces in 11.1.1.3 vs 11.1.1.4


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

Leave a Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s