| DESCRIPTION |
Use this format to export data to an Oracle table. Data will be exported
in comma-delimited format and non-numeric fields will be surrounded by
quotes. The user will be prompted for field names. The field names
should be the column_names in the Oracle table. Also, the user will need
to supply the maximum length of a record to be exported. By default, data
will be imported into a table with the same name as that of the export
template.
|
| USAGE NOTES |
This format produces a control file to be used with Oracle's SQL*LOADER
|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. 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
INTO_ORACLE.CTL would be:
|
