Preserve Your Database Customizations
Since the 19.3.0.0 database server code will be in a different directory from the 11g/12c code, you do not have to copy customized files to save your changes.
When you have finished your database installation:
- Copy the customized portions of the files into the Release 5.4 version of the file.
All customizable scripts are located in the same directories in Release 5.4 as in Release 4.6.2 or later. For information about customizing them, see the Oracle Clinical Administrator's Guide.
Table 4-2 Customizable Database Scripts and Packages
File Name | Location | Purpose of Customization | Changed? |
---|---|---|---|
ocl_add_user.sql |
$RXC_TOOLS |
Create new user accounts. |
Changed in 5.0, 5.1, and 5.4 |
ocstats.sql |
$RXC_INSTALL |
Gather statistics; see Run Scripts to Gather Schema Statistics for the Oracle Database Optimizer. |
New in 5.0, unchanged in 5.1, 5.2, or 5.4 |
opastats.sql |
$RXC_INSTALL |
Gather statistics; see Run Scripts to Gather Schema Statistics for the Oracle Database Optimizer. |
New in 5.0, unchanged in 5.1, 5.2, or 5.4 |
rxcptdxvb.sql |
$RXC_INSTALL |
Customize data extract views. |
Not changed |
pop_vb_static_views.sql |
$RXC_INSTALL |
Customize data extract views. |
Not changed |
ocl_client_pb.sql |
$RXC_INSTALL |
Customize to add PLSQL code to be invoked from various parts of the application. |
Not changed |
rdcpb_client.sql |
$RXC_INSTALL |
Customize flex fields for DCI Forms. |
Not changed |
OCL_UTILS |
$RXC_INSTALL |
See Oracle Clinical Creating a Study for information on customizing this package for making patients eligible for a PSDV plan and the Oracle Clinical Remote Data Capture Onsite Administrator's Guide for other uses. |
Changed in 5.1, not changed in 5.2 or 5.4 |
Parent topic: Upgrade Oracle Clinical Database Components on UNIX