Database Administration Guide
WebLogic Portal Database Definition Language (DDL) modules are provided in directories with the following format:
WL_HOME
/portal/db/
dbms_name
/
dbms_version
WL_HOME
/portal/db/pointbase/44
WL_HOME
/portal/db/oracle/817
WL_HOME
/portal/db/oracle/9i
Note: The same WebLogic Portal DDL is used for both Oracle 8.1.7 and 9i databases as indicated by a readme.txt
file in the oracle/9i
directory.This directory naming structure offers the ability to have distinct DDL between DBMS versions.
Data inserts for bootstrap data that must be inserted into tables in each WebLogic Portal database are contained in the following:
WL_HOME
/portal/db/data/required/xx_insert_system_required_data.sql
WebLogic Portal DDL is provided in files named as follows:
xx_create_fkeys.sql
xx_create_indexes.sql
xx_create_tables.sql
xx_create_triggers.sql
xx_create_views.sql
xx_drop_constraints.sql
xx_drop_fkeys.sql
xx_drop_indexes.sql
xx_drop_tables.sql
xx_drop_views.sql
where the xx is a prefix from the table below:
* Database object definitions for portlets from Compoze Software