ORACLE (FIXED FORMAT) (.008)    FOREIGN FORMAT (.44)

Name Value
NAME ORACLE (FIXED FORMAT)
SEND LAST FIELD DELIMITER? YES
FILE HEADER D ORACTL^DDXPLIB
DESCRIPTION
Use this format to export data to an Oracle table.  Data will be exported
in fixed format.  The user will be prompted for the length of each field
and the field name.  By default, the data will be imported into an Oracle
table with the same name as the export template used to export the data.
The field names should be the column_names in the Oracle table.
USAGE NOTES
This format produces a control file to be used with Oracle's SQL*LOADER
INTO_ORACLE.CTL would be:
|TAB|
       SQLLOAD USERID=username/password, CONTROL=INTO_ORACLE.CTL|TAB|
 
Of course, other options are available.  Consult your Oracle documentation.
utility to load data into a preexisting Oracle table.  The control file is
complete as created, but you may edit the file to modify the import.  By
default, the data will be imported into a table with the same name as that
of the export template.  Spaces in the export template name will be
converted to underscores (_). So, either that table must exist in your
Oracle table_space with the columns specified when the export template was
built or the exported file will need to be modified to show the correct
table_name.  A minimum syntax for loading an export file named
FORMAT USED? YES
RECORD LENGTH FIXED? YES
NEED FOREIGN FIELD NAMES? YES
MAXIMUM OUTPUT LENGTH 255