Upgrade Guide
This appendix includes details about WebLogic Portal Version 8.1 database changes for SP3. For information on previous releases, consult your support representative as needed.
If desired, you can preview the changes that will be made to schema objects during the database upgrade to Service Pack 3. To do so, review the file 81sp3_alter_table.sql
for the DBMS in which you are interested. You can find this file in the specific folder for your specific DBMS and version in the path WL_HOME
\portal\db\<
dbms>
\<
version>
. For example:
C:\bea813\weblogic81\portal\db\pointbase\44
The following tables are new in SP3:
Refer to the .sql
files prefixed "cmv_
" in the directory WL_HOME
/portal/d
b for your DBMS to review the DDL for the Virtual Content Management tables.
See the Data Dictionary for details about these new tables:
http://download.oracle.com/docs/cd/E13218_01/wlp/docs81/db/4Schemas.html
For Virtual Content Management a new column named LIFECYCLE_STATUS
is included in the CM_NODE table. LIFECYCLE_STATUS
identifies the lifecycle status (for example, In Progress, Published, and so on) for this node. The default for new or existing nodes is 4, Published.
See the file named 81sp3_alter_tables.sql under WL_HOME
/portal/db
for your DBMS to view the DDL for this column addition.
The following tables are new in SP3:
See the Data Dictionary for details about these new tables:
http://download.oracle.com/docs/cd/E13218_01/wlp/docs81/db/4Schemas.html
See the .sql
files prefixed "wsrp_
" under WL_HOME
/portal/db
for your DBMS to view the DDL for the Web Services Remote Portals tables.
The following changes occurred in SP3:
See the file named 81sp3_alter_tables.sql
under WL_HOME
/portal/db
for your DBMS to review the DDL for the above changes.
The following changes were made for each DBMS that WebLogic Portal supports.
See the file named 81sp3_alter_tables.sql
under WL_HOME
/portal/db
for your DBMS to review the DDL for the above changes and additions.