Rename the Existing "Clinical One Operational Data" Data Models

Execute the cdrc1suppdmrename.sql script to rename all the existing "Clinical One Operational Data" data models to "Clinical One Supplementary Data".

Note:

Run this script only if you are upgrading to Oracle DMW 3.4.1 and have studies loaded from Clinical One (using DMW-C1 integration) in any of the previous versions of Oracle DMW.

Follow these steps to run the script on a computer with an Oracle client that can connect to the Oracle DMW database server using SQLPlus:

1. Download the file from $CDR_TOP/patch/115/sql/cdrc1suppdmrename.sql.
2. Log in to SQLPlus (not SQLDeveloper) as the APPS database user.
3. Invoke the script from your download directory:
   <download_directory>/cdrc1suppdmrename.sql