Fixed-Length option

Choose Import Data > Fixed-Length to import data in fixed-length format. When you choose this option, the Data Dictionary alphabetically lists all the tables defined for your database. When you select a table, the Import Fixed-Length dialog box shown in the following figure appears.

Figure 1. Import Fixed-Length dialog box


The Import Fixed-Length dialog box contains the following user-interface elements:

  • Effective Tenant — For databases enabled for multi-tenancy, the tenant of the data being imported (not shown in the following figure).
  • Import File Specifies the load file
  • Disable Triggers During Import — Specifies whether to disable triggers during the import

After you choose OK from the Import Fixed-Length dialog box, the Fixed-Length Field Columns dialog box shown in the following figure appears.

Figure 2. Fixed-Length Field Columns dialog box


The Fixed-Length Field Columns dialog box lists the fields you can import.