The Insert Process generates an Insert Process Report that
provides general information and statistics about the Insert Process.
The following is a sample:
The Insert Process Report displays
the following information:
- Name of the Insert Request (or Untitled if
you did not save the request).
- Name of the Server or Local, for client workstation.
- Name of the Source file used as input to the process.
- Name of the Control File specified in the Insert
Request.
- Name of the Table Map or LOCAL, as specified in
the Insert Request.
- Indicator (Skipped or Processed)
for processing file attachments.
- User IDs of the user requesting the Insert Process.
- Date and time the Insert Process started.
- Date and time the Insert Process completed.
- Elapsed time for the Insert Process to complete.
Errors
If any
errors or warnings occur during processing, a list of the errors or
warnings is provided. Review the list of errors that caused processing
to stop. For example, an internal error condition exists when the
process exceeds the discard row limit or if you are not authorized
to access a particular database table.
Process Summary
Statistics
are provided for the inserted data:
- Total number of Tables Processed.
- Total number of Rows Inserted.
- Total number of Rows Updated.
- Total number of Rows with Errors.
Row Details
Information
is provided for each table:
- Number of rows inserted.
- Number of rows updated.
- Number of failed rows.
- List of tables used in the Insert Process. The tables
are listed in the same order as in the source file.