Execute the cdrretifytable.sql Script

If you are upgrading from Oracle LSH release 2.2.x or 2.4.9.x to release 3.1, you must execute the cdrretifytable.sql script. However, if you have already executed this script earlier successfully in release 2.4.9.x, you need not execute this script again.

For executable objects like programs and data marts, the script validates that the BLINDING_UPGRADABLE_RC attribute is set correctly for the LSH 2.2.x tables. If the attribute is set incorrectly, the script updates it to use the correct value. In addition, if the BLINDING_UPGRADABLE_RC attribute is set incorrectly, the script re-installs text Load Sets and their target tables.

1. Log on to the application tier.
2. Source the environment file.
3. Navigate to the $CDR_TOP/patch/115/sql directory.
4. Log in to SQL*Plus as the APPS user.
5. Execute the script cdrretifytable.sql.
   This script validates whether or not the Oracle LSH 2.2.x or 2.4.9.x tables are compatible with Oracle LSH 3.1. This script also submits the job "CDR_UPGRADEFROM22".
6. To track the job status, execute the following query:
   select job_name,state from DBA_SCHEDULER_JOBS where job_name='CDR_UPGRADEFROM22';
7. To monitor the job while it is executing, execute the following query:
   SELECT job_name,session_id,running_instance FROM DBA_SCHEDULER_RUNNING_JOBS WHERE JOB_NAME = 'CDR_UPGRADEFROM22';
8. To check the script execution status after the scheduler job is completed, execute the following query:
   select job_name,status,error#,additional_info from dba_scheduler_job_run_details where job_name='CDR_UPGRADEFROM22';
9. After the script execution is completed, extract the output from the CDR_EXE_DEBUG table by executing the following query:
   select logentry from cdr_exe_debug where location='UPGRADEFROM22' order by seq;