Export Data

1. Go to Utilities\Copy_Config and run the Data_ExportConfigOnly.bat file.
   The Export Utility command prompt screen appears.
2. 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 export dump files (database server file path)

      Enter a directory path specific to your database environment.

      The Export Dump file and Export log file will be placed here as INSIGHT.DMP and Export_log.log respectively.

   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 file and files named application_type_check.sql, insight_export_tables.par, and truncate_delete_tables.sql will be generated here.

   9. Name of the log file
3. 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.

4. 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.

5. Press Enter if the Directory Path is valid.
6. 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.

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

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

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

   A data export completed screen appears with a list of all the output files.

9. Verify the location of files, and press Enter to Exit.

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