Merge Import

1. From the Start menu, navigate to the following path:

   Argus Release Media\Database\Argus Safety\Utilities\Merge_to_Multitenant

2. Click merge_import.bat and enter the following parameters for the target database:
   1. Log File Name to record results.

      This is the execution log that will be created on the client workstation.

      Log file path: Argus Release Media\Database\Argus Safety\Utilities\Merge_to_Multitenant

   2. TNSNAMES entry to connect to the target Safety database.
   3. SYSTEM or DBA user name.
   4. Password of the DBA user.
   5. VPD schema owner name.
   6. Password of the VPD schema owner.
   7. SAFETY schema owner name.
   8. Password of the Oracle Argus Safety schema owner.
   9. Oracle Argus Interchange schema owner name.
   10. Password of the Oracle Argus Interchange schema owner.
   11. Directory location where the export dmp file is copied for the import process.

       This is the path on the Target Database Server where the Oracle Argus Safety database is installed. The batch file creates an import log file in this directory.

   12. Name of the new enterprise.
   13. Abbreviation of the new enterprise.
   14. SAFETY schema owner name in the source database.
   15. Oracle Argus Interchange schema owner name in source database.
3. This batch file imports the data from the dump file into the target database.
4. Make sure that no error has occurred during import by checking the following log files:
   • Log file name entered as parameter 1 during Import step execution.
   • The following Oracle Import log files are created on database server. The path is the value entered in “Enter Directory including full Path on target database server where export dmp file copied for import process" during import step.
     • SAFETY_IMPORT_safety.log
     • SAFETY_IMPORT_interchange.log
     • SAFETY_IMPORT_SAFETY_DUP_SEARCH_DATA.log
     • SAFETY_IMPORT_SAFETY_DUP_LAM_SEARCH_DATA.log
5. Validate the schema of the database using the SchemaValidation.bat file.