Table Information - Oracle 8i

The Table Information Section provides the following entries for each table loaded:

  1. Table name
  2. Load conditions, if any. That is, whether all records were loaded or only those meeting WHEN- clause criteria.
  3. INSERT, APPEND, or REPLACE specification
  4. The following column information:
  • If found in datafile, the position, length, datatype, and delimiter.
  • If specified, RECNUM, SEQUENCE, or CONSTANT
  • If specified, DEFAULTIF or NULLIF

For example:

Table EMP, loaded from every logical record.
Insert option in effect for this table: REPLACE


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Oracle 8i Topics