6 Perform the Post-Migration Steps

Perform the following post-migration steps:

1. Use backed up HDR delete API PLSQL package (hdr_delete_api.sql) for deleting transactional data (or persisted object graphs) from Oracle HDR 8.2 CTB tables.
   1. Connect to HDR database (locally from the database machine or remotely using sqlplus) as "ctb" user.
   2. Execute the hdr_delete_api.sql file that will compile the HDR delete API PLSQL package "HDR_DELETE_API". The package should compile successfully.
2. Drop the existing HDR Bulk Data Loader job by executing the following SQL scripts from sqlplus/sqldeveloper as sys user:
   1. exec dbms_scheduler.drop_job('hdr_bdl_scheduler_job',TRUE);
   2. exec dbms_scheduler.drop_program('hdr_bdl_scheduler_program')
3. Create the HDR Bulk Data Loader Job. To create the HDR Bulk Data Loader job, perform the following:
   1. Create Bulk Data Loader log directory by executing the following SQL script from the sqlplus/sqldeveloper as ctb user. The SQL script accepts the absolute path of CTB concurrent program libraries folder on the database server as an argument.

      @$HDR_HOME/database/db/ctb/create/directory/create_bdl_log_directory.sql  $HDR_HOME/database/hdr_cp_lib

   2. Create Bulk Data Loader Job by executing the following SQL script from the sqlplus/sqldeveloper as sys user. The SQL script accepts, 1. Absolute path of the java executable on the database server, 2. Absolute path of CTB concurrent program libraries folder on the database server, 3. CTB user password as an arguments.

      @$HDR_HOME/database/db/ctb/create/jobs/hdr_bulk_loader_job.sql $JAVA_HOME/bin/java $HDR_HOME/database/hdr_cp_lib <CTB_DB_USER_PASSWORD>