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
|