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:

1. 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