Running HDR Importer Jobs

To run a HDR importer job, perform the following:

1. Log in to the database machine as ORACLE_OWNER user and navigate to the $HDR_HOME/ hdr_db/ets/db/execute folder.
2. Execute the following commands:

   su $ORACLE_OWNER
   

   Use the preceding command if you are not logged in as $ORACLE_OWNER user.

   cd $HDR_HOME/hdr_db/ets/db/execute
   

3. Update the run_ets_importer.sql script with required job arguments.

   Substitute &1 with the load sequence number, which is available from execution report of the HDR loader job.

4. Log in to the database as sysdba user.
5. Execute the following command:

   sqlplus sys@$SID as sysdba
   

   Provide the password when prompted.

6. Execute the following script:

   @ run_ets_importer.sql;
   

7. Check the log file and execution report for status.

   The log file is generated when the job starts and the execution report is generated when the job ends. These files are located in the $HDR_HOME/ hdr_db/ets/log folder.