Import Data

1. Go to Utilities\Copy_Config and run the Data_ImportConfigOnly.bat file.

   The Import Utility command prompt screen appears.

2. Press Enter if all prerequisites are satisfied.
3. Enter the following details when prompted, and press Enter:
   1. TNSNAMES entry of the Oracle Argus Insight Database
   2. DBA User
   3. DBA User Password
   4. Oracle Argus Mart Schema Owner Name
   5. Oracle Argus Mart Schema Owner Password

   6. DB Directory path for import dump files (database server file path)

      Enter a directory path specific to your database environment.

      INSIGHT.DMP created in the export process is copied here. Beside, Import_log.log is also created here.

   7. Directory Name (in capital letters) to be created in the database

      A database directory is created with this name at the path mentioned in the previous step.

   8. Directory including full path for log/script files (Local Machine)

      Enter a directory path specific to the machine where the Copy Configuration utility is being run.

      The user specified log files are generated here.

      Besides, make sure that the files named application_type_check.sql, insight_export_tables.par, and truncate_delete_tables.sql that were generated during export process are also copied here.

   9. Name of the log file
4. Verify that the script is successfully connected as <DBA User Name>@<Oracle Argus Insight Database Name>, and press Enter.

   The command prompt screen with the Encryption Wallet Verification status appears.

5. Verify the details mentioned on the command prompt screen, and press Enter if:
   • TDE is setup and Wallet is open
   • TDE is not setup and Wallet is not open

   The command prompt screen with Directory Creation status appears.

6. Press Enter if the Directory Path is valid.
7. Verify that the script is successfully connected as <APR_MART User Name>@<Oracle Argus Insight Database Name>, and press Enter.

   The command prompt screen with list of parameters appears.

8. Press Enter to resume if the parameters are valid.

   Verify the details mentioned on the command prompt screen, and press Enter.

9. Enter the password for the APR_MART user, and press Enter.

   A data import completed screen appears.

10. Press Enter to Exit.

    Make sure to review the all the log files for information about the import and import errors.